New Members and Constants_Excel.Dev
Properties 
Description 

This object or member has been deprecated, but it remains part of the object model for backward compatibility. You should not use it in new applications.  
Returns or sets how Excel will validate files before opening them. Read/write  
Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Readonly  
Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Readonly.  
Returns a handle to the instance of Microsoft Excel 2010 represented by the Application object. Readonly Variant.  
Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write  
Returns the set of SmartArt layouts that are currently loaded in the application. Readonly  
Returns an AddIns2 collection that represents all the addins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Readonly  
Returns or sets whether Excel uses high quality mode to print graphics. Read/write  
Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Readonly. Returns Nothing if there are no Protected View windows open. Readonly  
Specifies whether communication with the printer is turned on. Boolean Read/write  
Returns the set of color styles that are currently loaded in the application. Readonly  
Returns True if the specified workbook is open in a Protected View window. Readonly  
Returns the set of SmartArt quick styles which are currently loaded in the application. Readonly  
Returns or sets whether Excel allows userdefined functions in XLL addins to be run on a compute cluster. Read/write  
Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run userdefined functions in XLL addins. Read/write 
Events 
Description 

Occurs when a Protected View window is activated.  
Occurs before changes are committed against the OLAP data source for a PivotTable.  
Occurs immediately before a Protected View window or a workbook in a Protected View window closes.  
Occurs before changes to a PivotTable are discarded.  
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).  
Occurs before changes are applied to a PivotTable.  
Occurs when a new chart is created in any open workbook.  
Occurs when a workbook is opened in a Protected View window.  
Occurs immediately before editing is enabled on the workbook in the specified Protected View window.  
Occurs when any Protected View window is resized.  
Occurs when a Protected View window is deactivated.  
Occurs after the workbook is saved. 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Returns the height, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Returns the width, in points, of the object. Readonly. 
Properties 
Description 

Returns whether the specified named set is recalculated with every update. Readonly  
Returns or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write  
Returns or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube. Read/write  
Returns the display folder name for a named set. Readonly 
Properties 
Description 

Returns the number of comment pages that will be printed for the current chart. Readonly  
Returns or sets whether to display legend field buttons on a PivotChart. Read/write  
Returns or sets whether to display the value field buttons on a PivotChart. Read/write  
Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write  
Returns or sets whether to display all field buttons on a PivotChart. Read/write  
Returns or sets whether to display axis field buttons on a PivotChart. Read/write 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Returns the height, in points, of the object. Readonly.  
Returns the width, in points, of the object. Readonly. 
Properties 
Description 

Returns or sets whether to order and remove duplicates when displaying the specified hierarchy field in a PivotTable report based on an OLAP cube. Read/write  
Returns or sets whether items from all levels of the specified hierarchy field are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write 
Properties 
Description 

Returns or sets how a data bar is filled with color. Read/write  
Returns or sets the position of the axis of the data bars specified by a conditional formatting rule. Read/write  
Returns the color of the axis for cells with conditional formatting as data bars. Readonly  
Returns or sets the order in which the cells will be spoken. The value of the Direction property is an XlSpeakDirection constant. Read/write.  
Returns the NegativeBarFormat object associated with a data bar conditional formatting rule. Readonly  
Returns an object that specifies the border of a data bar. Readonly 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Returns the height, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Returns the width, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write. 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Returns the height, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Returns the width, in points, of the object. Readonly. 
Properties 
Description 

Returns or sets the locale identifier for the specified connection. Read/write  
Returns the CalculatedMembers collection for the specified connection. Readonly 
Methods 
Description 

Drops and then reconnects the specified connection. 
Properties 
Description 

Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Readonly 
Properties 
Description 

Returns a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source. Readonly  
Returns whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. Readonly  
Returns the value last retrieved from the data source for edited cells in a PivotTable report. Readonly 
Methods 
Description 

Discards changes to the specified cell in a PivotTable report.  
Performs a writeback operation on the specified cell in a PivotTable report based on an OLAP data source. 
Properties 
Description 

Returns or sets whether the values row is displayed. Read/write  
Returns or sets what method to use to allocate values when performing whatif analysis on a PivotTable report based on an OLAP data source. Read/write  
Returns or sets whether writing back to the data source is enabled for the specified PivotTable. The default value is False. Read/write.  
Returns or sets the descriptive (alternative) text string for the specified PivotTable. Read/write  
Returns the Slicers collection for the specified PivotTable. Readonly  
Returns or sets whether to include filtered items in the totals of named sets for the specified PivotTable. Read/write  
Returns or sets what value to allocate when performing whatif analysis on a PivotTable report based on an OLAP data source. Read/write  
Returns the PivotTableChangeList collection that represents the list of changes that have been made to the specified PivotTable based on an OLAP data source. Readonly  
Returns or sets the MDX weight expression to use when performing whatif analysis on a PivotTable report based on an OLAP data source. Read/write  
Returns or sets the description associated with the alternative text string for the specified table. Read/write  
Returns or sets whether to run an UPDATE CUBE statement for each cell is edited, or only when the user chooses to calculate changes when performing whatif analysis on a PivotTable based on an OLAP data source. Read/write  
Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write 
Methods 
Description 

Performs a commit operation on the data source of a PivotTable report based on an OLAP data source.  
Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.  
Retrieves the current values from the data source for all edited cells in a PivotTable report that is in writeback mode.  
Discards all changes in the edited cells of a PivotTable report.  
Performs a writeback operation for all edited cells in a PivotTable report based on an OLAP data source. 
Properties 
Description 

Returns the width, in points, of the object. Readonly.  
Returns the object name. Readonly.  
Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Readonly.  
Returns the height, in points, of the object. Readonly.  
Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Readonly. 
Methods 
Description 

Returns the vertical or horizontal position of a point on a chart item, in points, from the top or left edge of the object to the top or left edge of the chart area. 
Properties 
Description 

Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Readonly  
Returns a DisplayFormat object that represents the display settings for the specified range. Readonly 
Methods 
Description 

Discards all changes in the edited cells of the range.  
Removes all hyperlinks from the specified range.  
Performs a writeback operation for all edited cells in a range based on an OLAP data source. 
Properties 
Description 

Returns or sets whether the spelling checker uses rules regarding Arabic words beginning with an alef hamza. Read/write  
Returns or sets whether the spelling checker uses rules to flag Arabic words ending with haa instead of taa marboota. Read/write  
Returns or sets the mode for checking the spelling of Brazilian Portuguese. Read/write  
Returns or sets whether the spelling checker uses rules regarding Arabic words ending with the letter yaa. Read/write  
Returns or sets whether the spelling checker uses rules regarding Russian words containing the character ë. Read/write  
Returns or sets the mode for checking the spelling of European Portuguese. Read/write  
Returns or sets the mode for checking the spelling of Spanish. Read/write 
Properties 
Description 

Returns an object that represents the active slicer in the active workbook or in the specified workbook. Returns Nothing if no slicer is active. Readonly.  
Returns the SlicerCaches object associated with the workbook. Readonly.  
Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results. Read/write  
Specifies the style from the TableStyles object that is used as the default style for slicers. Read/write. 
Methods 
Description 

Saves a workbook to a server from a local computer, and sets the local workbook to readonly so that it cannot be edited locally. 
Events 
Description 

Occurs when a new chart is created in the workbook.  
Occurs after changes to a PivotTable.  
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).  
Occurs before changes to a PivotTable are discarded.  
Occurs before changes are applied to a PivotTable.  
Occurs before changes are committed against the OLAP data source for a PivotTable.  
Occurs after the workbook is saved. 
Properties 
Description 

Returns the number of comment pages that will be printed for the current worksheet. Readonly 
Events 
Description 

Occurs after changes to a PivotTable.  
Occurs before changes are applied to a PivotTable.  
Occurs before changes to a PivotTable are discarded.  
Occurs before changes are committed against the OLAP data source for a PivotTable.  
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas). 
Methods 
Description 

Returns the natural logarithm of the gamma function, Γ(x).  
Returns the error function integrated between zero and lower_limit.  
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).  
Calculates variance based on the entire population.  
Returns the inverse of the righttailed F probability distribution. If p = F_DIST_RT(x,...), then F_INV_RT(p,...) = x.  
Returns the negative binomial distribution. NEGBINOM_DIST returns the probability that there will be number_f failures before the number_sth success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.  
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.  
Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.  
Estimates variance based on a sample.  
Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis.  
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.  
Returns the chisquared distribution.  
Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.  
Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.  
Returns a value that you can use to construct a confidence interval for a population mean.  
Returns the righttailed probability of the chisquared distribution.  
Returns the twotailed Student tdistribution.  
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)  
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK_INC to evaluate the standing of an aptitude test score among all scores for the test.  
Returns the most frequently occurring, or repetitive, value in an array or range of data.  
Returns the beta cumulative distribution function.  
Returns the individual term binomial distribution probability.  
Returns the lefttailed inverse of the Student tdistribution.  
Returns the inverse of the lefttailed probability of the chisquared distribution.  
Returns the specified number rounded to the nearest multiple of significance.  
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.  
Returns the kth percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can examine candidates who score above the 90th percentile.  
Returns an aggregate in a list or database.  
Returns the rank of a number in a list of numbers; that is its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.  
Returns the righttailed F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school and determine if the variability in the females is different from that found in the males.  
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.  
Returns the righttailed Student tdistribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The tdistribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the tdistribution.  
Returns the inverse of the cumulative distribution function for a specified beta distribution. That is, if probability = Beta_Dist(x,...), then Beta_Inv(probability,...) = x.  
Returns population covariance, the average of the products of deviations for each data point pair.  
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in one minute.  
Returns the F probability distribution.  
Returns the quartile of a data set based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE_INC to find the top 25 percent of incomes in a population.  
Returns the tvalue of the Student tdistribution as a function of the probability and the degrees of freedom.  
Returns the inverse of the F probability distribution.  
Rounds the specified number to the nearest multiple of significance.  
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.  
Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.  
Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data.  
Returns the complementary error function integrated between the specified value and infinity.  
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.  
Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.  
Returns the kth percentile of values in a range, where k is in the range 0..1, exclusive.  
Returns the confidence interval for a population mean, using a Student's t distribution.  
Returns the inverse of the gamma cumulative distribution. If p = GAMMA_DIST(x,...), then GAMMA_INV(p,...) = x.  
Returns the inverse of the individual term binomial distribution probability.  
Returns the hypergeometric distribution. HYPGEOM_DIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOM_DIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.  
Returns the onetailed probabilityvalue of a ztest. For a given hypothesized population mean, Z_TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.  
Returns the exponential distribution. Use EXPON_DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON_DIST to determine the probability that the process takes at most 1 minute.  
Returns the result of an Ftest. An Ftest returns the twotailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public and private schools, you can test whether these schools have different levels of test score diversity.  
Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).  
Returns the probability associated with a Student tTest. Use T_TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.  
Returns the inverse of the righttailed probability of the chisquared distribution.  
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device.  
Returns a Student tdistribution where a numeric value (x) is a calculated value of t for which the Percentage Points are computed.  
Returns the test for independence.  
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one. 
The following constants have been added to existing enumerations in Microsoft Excel 2010.
Enumeration 
New Constants 

 
 
 
 
 
 

Properties 
Description 

This object or member has been deprecated, but it remains part of the object model for backward compatibility. You should not use it in new applications.  
Returns or sets how Excel will validate files before opening them. Read/write  
Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Readonly  
Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Readonly.  
Returns a handle to the instance of Microsoft Excel 2010 represented by the Application object. Readonly Variant.  
Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write  
Returns the set of SmartArt layouts that are currently loaded in the application. Readonly  
Returns an AddIns2 collection that represents all the addins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Readonly  
Returns or sets whether Excel uses high quality mode to print graphics. Read/write  
Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Readonly. Returns Nothing if there are no Protected View windows open. Readonly  
Specifies whether communication with the printer is turned on. Boolean Read/write  
Returns the set of color styles that are currently loaded in the application. Readonly  
Returns True if the specified workbook is open in a Protected View window. Readonly  
Returns the set of SmartArt quick styles which are currently loaded in the application. Readonly  
Returns or sets whether Excel allows userdefined functions in XLL addins to be run on a compute cluster. Read/write  
Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run userdefined functions in XLL addins. Read/write 
Events 
Description 

Occurs when a Protected View window is activated.  
Occurs before changes are committed against the OLAP data source for a PivotTable.  
Occurs immediately before a Protected View window or a workbook in a Protected View window closes.  
Occurs before changes to a PivotTable are discarded.  
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).  
Occurs before changes are applied to a PivotTable.  
Occurs when a new chart is created in any open workbook.  
Occurs when a workbook is opened in a Protected View window.  
Occurs immediately before editing is enabled on the workbook in the specified Protected View window.  
Occurs when any Protected View window is resized.  
Occurs when a Protected View window is deactivated.  
Occurs after the workbook is saved. 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Returns the height, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Returns the width, in points, of the object. Readonly. 
Properties 
Description 

Returns whether the specified named set is recalculated with every update. Readonly  
Returns or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write  
Returns or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube. Read/write  
Returns the display folder name for a named set. Readonly 
Properties 
Description 

Returns the number of comment pages that will be printed for the current chart. Readonly  
Returns or sets whether to display legend field buttons on a PivotChart. Read/write  
Returns or sets whether to display the value field buttons on a PivotChart. Read/write  
Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write  
Returns or sets whether to display all field buttons on a PivotChart. Read/write  
Returns or sets whether to display axis field buttons on a PivotChart. Read/write 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Returns the height, in points, of the object. Readonly.  
Returns the width, in points, of the object. Readonly. 
Properties 
Description 

Returns or sets whether to order and remove duplicates when displaying the specified hierarchy field in a PivotTable report based on an OLAP cube. Read/write  
Returns or sets whether items from all levels of the specified hierarchy field are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write 
Properties 
Description 

Returns or sets how a data bar is filled with color. Read/write  
Returns or sets the position of the axis of the data bars specified by a conditional formatting rule. Read/write  
Returns the color of the axis for cells with conditional formatting as data bars. Readonly  
Returns or sets the order in which the cells will be spoken. The value of the Direction property is an XlSpeakDirection constant. Read/write.  
Returns the NegativeBarFormat object associated with a data bar conditional formatting rule. Readonly  
Returns an object that specifies the border of a data bar. Readonly 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Returns the height, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Returns the width, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write. 
Properties 
Description 

Gets or sets a String value that represents the formula of the object using A1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in English. Read/write.  
Gets or sets a String value that represents the formula of the object using A1style notation, in the language of the user. Read/write.  
Returns the height, in points, of the object. Readonly.  
Gets or sets a String value that represents the formula of the object using R1C1style notation, in the language of the user. Read/write.  
Returns the width, in points, of the object. Readonly. 
Properties 
Description 

Returns or sets the locale identifier for the specified connection. Read/write  
Returns the CalculatedMembers collection for the specified connection. Readonly 
Methods 
Description 

Drops and then reconnects the specified connection. 
Properties 
Description 

Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Readonly 
Properties 
Description 

Returns a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source. Readonly  
Returns whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. Readonly  
Returns the value last retrieved from the data source for edited cells in a PivotTable report. Readonly 
Methods 
Description 

Discards changes to the specified cell in a PivotTable report.  
Performs a writeback operation on the specified cell in a PivotTable report based on an OLAP data source. 
Properties 
Description 

Returns or sets whether the values row is displayed. Read/write  
Returns or sets what method to use to allocate values when performing whatif analysis on a PivotTable report based on an OLAP data source. Read/write  
Returns or sets whether writing back to the data source is enabled for the specified PivotTable. The default value is False. Read/write.  
Returns or sets the descriptive (alternative) text string for the specified PivotTable. Read/write  
Returns the Slicers collection for the specified PivotTable. Readonly  
Returns or sets whether to include filtered items in the totals of named sets for the specified PivotTable. Read/write  
Returns or sets what value to allocate when performing whatif analysis on a PivotTable report based on an OLAP data source. Read/write  
Returns the PivotTableChangeList collection that represents the list of changes that have been made to the specified PivotTable based on an OLAP data source. Readonly  
Returns or sets the MDX weight expression to use when performing whatif analysis on a PivotTable report based on an OLAP data source. Read/write  
Returns or sets the description associated with the alternative text string for the specified table. Read/write  
Returns or sets whether to run an UPDATE CUBE statement for each cell is edited, or only when the user chooses to calculate changes when performing whatif analysis on a PivotTable based on an OLAP data source. Read/write  
Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write 
Methods 
Description 

Performs a commit operation on the data source of a PivotTable report based on an OLAP data source.  
Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.  
Retrieves the current values from the data source for all edited cells in a PivotTable report that is in writeback mode.  
Discards all changes in the edited cells of a PivotTable report.  
Performs a writeback operation for all edited cells in a PivotTable report based on an OLAP data source. 
Properties 
Description 

Returns the width, in points, of the object. Readonly.  
Returns the object name. Readonly.  
Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Readonly.  
Returns the height, in points, of the object. Readonly.  
Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Readonly. 
Methods 
Description 

Returns the vertical or horizontal position of a point on a chart item, in points, from the top or left edge of the object to the top or left edge of the chart area. 
Properties 
Description 

Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Readonly  
Returns a DisplayFormat object that represents the display settings for the specified range. Readonly 
Methods 
Description 

Discards all changes in the edited cells of the range.  
Removes all hyperlinks from the specified range.  
Performs a writeback operation for all edited cells in a range based on an OLAP data source. 
Properties 
Description 

Returns or sets whether the spelling checker uses rules regarding Arabic words beginning with an alef hamza. Read/write  
Returns or sets whether the spelling checker uses rules to flag Arabic words ending with haa instead of taa marboota. Read/write  
Returns or sets the mode for checking the spelling of Brazilian Portuguese. Read/write  
Returns or sets whether the spelling checker uses rules regarding Arabic words ending with the letter yaa. Read/write  
Returns or sets whether the spelling checker uses rules regarding Russian words containing the character ë. Read/write  
Returns or sets the mode for checking the spelling of European Portuguese. Read/write  
Returns or sets the mode for checking the spelling of Spanish. Read/write 
Properties 
Description 

Returns an object that represents the active slicer in the active workbook or in the specified workbook. Returns Nothing if no slicer is active. Readonly.  
Returns the SlicerCaches object associated with the workbook. Readonly.  
Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results. Read/write  
Specifies the style from the TableStyles object that is used as the default style for slicers. Read/write. 
Methods 
Description 

Saves a workbook to a server from a local computer, and sets the local workbook to readonly so that it cannot be edited locally. 
Events 
Description 

Occurs when a new chart is created in the workbook.  
Occurs after changes to a PivotTable.  
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).  
Occurs before changes to a PivotTable are discarded.  
Occurs before changes are applied to a PivotTable.  
Occurs before changes are committed against the OLAP data source for a PivotTable.  
Occurs after the workbook is saved. 
Properties 
Description 

Returns the number of comment pages that will be printed for the current worksheet. Readonly 
Events 
Description 

Occurs after changes to a PivotTable.  
Occurs before changes are applied to a PivotTable.  
Occurs before changes to a PivotTable are discarded.  
Occurs before changes are committed against the OLAP data source for a PivotTable.  
Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas). 
Methods 
Description 

Returns the natural logarithm of the gamma function, Γ(x).  
Returns the error function integrated between zero and lower_limit.  
Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).  
Calculates variance based on the entire population.  
Returns the inverse of the righttailed F probability distribution. If p = F_DIST_RT(x,...), then F_INV_RT(p,...) = x.  
Returns the negative binomial distribution. NEGBINOM_DIST returns the probability that there will be number_f failures before the number_sth success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.  
Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.  
Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.  
Estimates variance based on a sample.  
Returns the gamma distribution. You can use this function to study variables that may have a skewed distribution. The gamma distribution is commonly used in queuing analysis.  
Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.  
Returns the chisquared distribution.  
Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.  
Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Use this function to analyze data that has been logarithmically transformed.  
Returns a value that you can use to construct a confidence interval for a population mean.  
Returns the righttailed probability of the chisquared distribution.  
Returns the twotailed Student tdistribution.  
Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)  
Returns the rank of a value in a data set as a percentage (0..1, inclusive) of the data set. This function can be used to evaluate the relative standing of a value within a data set. For example, you can use PERCENTRANK_INC to evaluate the standing of an aptitude test score among all scores for the test.  
Returns the most frequently occurring, or repetitive, value in an array or range of data.  
Returns the beta cumulative distribution function.  
Returns the individual term binomial distribution probability.  
Returns the lefttailed inverse of the Student tdistribution.  
Returns the inverse of the lefttailed probability of the chisquared distribution.  
Returns the specified number rounded to the nearest multiple of significance.  
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.  
Returns the kth percentile of values in a range. You can use this function to establish a threshold of acceptance. For example, you can examine candidates who score above the 90th percentile.  
Returns an aggregate in a list or database.  
Returns the rank of a number in a list of numbers; that is its size relative to other values in the list. If more than one value has the same rank, the average rank is returned.  
Returns the righttailed F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school and determine if the variability in the females is different from that found in the males.  
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Weekend days and any days that are specified as holidays are not considered as workdays.  
Returns the righttailed Student tdistribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The tdistribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the tdistribution.  
Returns the inverse of the cumulative distribution function for a specified beta distribution. That is, if probability = Beta_Dist(x,...), then Beta_Inv(probability,...) = x.  
Returns population covariance, the average of the products of deviations for each data point pair.  
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in one minute.  
Returns the F probability distribution.  
Returns the quartile of a data set based on percentile values from 0..1, inclusive. Quartiles often are used in sales and survey data to divide populations into groups. For example, you can use QUARTILE_INC to find the top 25 percent of incomes in a population.  
Returns the tvalue of the Student tdistribution as a function of the probability and the degrees of freedom.  
Returns the inverse of the F probability distribution.  
Rounds the specified number to the nearest multiple of significance.  
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.  
Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.  
Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data.  
Returns the complementary error function integrated between the specified value and infinity.  
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.  
Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.  
Returns the kth percentile of values in a range, where k is in the range 0..1, exclusive.  
Returns the confidence interval for a population mean, using a Student's t distribution.  
Returns the inverse of the gamma cumulative distribution. If p = GAMMA_DIST(x,...), then GAMMA_INV(p,...) = x.  
Returns the inverse of the individual term binomial distribution probability.  
Returns the hypergeometric distribution. HYPGEOM_DIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size. Use HYPGEOM_DIST for problems with a finite population, where each observation is either a success or a failure, and where each subset of a given size is chosen with equal likelihood.  
Returns the onetailed probabilityvalue of a ztest. For a given hypothesized population mean, Z_TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.  
Returns the exponential distribution. Use EXPON_DIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPON_DIST to determine the probability that the process takes at most 1 minute.  
Returns the result of an Ftest. An Ftest returns the twotailed probability that the variances in array1 and array2 are not significantly different. Use this function to determine whether two samples have different variances. For example, given test scores from public and private schools, you can test whether these schools have different levels of test score diversity.  
Calculates standard deviation based on the entire population given as arguments. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).  
Returns the probability associated with a Student tTest. Use T_TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.  
Returns the inverse of the righttailed probability of the chisquared distribution.  
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device.  
Returns a Student tdistribution where a numeric value (x) is a calculated value of t for which the Percentage Points are computed.  
Returns the test for independence.  
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one. 
The following constants have been added to existing enumerations in Microsoft Excel 2010.
Enumeration 
New Constants 

 
 
 
 
 
 
