New Members and Constants_Excel.Dev

New Members

The following properties, methods, and events have been added to existing objects in Microsoft Excel 2010.

AddIn

Properties	Description
IsOpen	Returns True if the add-in is currently open. Boolean Read-only

Application

Properties	Description
SaveISO8601Dates	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.
FileValidation	Returns or sets how Excel will validate files before opening them. Read/write
ProtectedViewWindows	Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Read-only
FileExportConverters	Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.
HinstancePtr	Returns a handle to the instance of Microsoft Excel 2010 represented by the Application object. Read-only Variant.
FileValidationPivot	Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write
SmartArtLayouts	Returns the set of SmartArt layouts that are currently loaded in the application. Read-only
AddIns2	Returns an AddIns2 collection that represents all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Read-only
HighQualityModeForGraphics	Returns or sets whether Excel uses high quality mode to print graphics. Read/write
ActiveProtectedViewWindow	Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Read-only. Returns Nothing if there are no Protected View windows open. Read-only
PrintCommunication	Specifies whether communication with the printer is turned on. Boolean Read/write
SmartArtColors	Returns the set of color styles that are currently loaded in the application. Read-only
IsSandboxed	Returns True if the specified workbook is open in a Protected View window. Read-only
SmartArtQuickStyles	Returns the set of SmartArt quick styles which are currently loaded in the application. Read-only
UseClusterConnector	Returns or sets whether Excel allows user-defined functions in XLL add-ins to be run on a compute cluster. Read/write
ClusterConnector	Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins. Read/write

Events	Description
ProtectedViewWindowActivate	Occurs when a Protected View window is activated.
SheetPivotTableBeforeCommitChanges	Occurs before changes are committed against the OLAP data source for a PivotTable.
ProtectedViewWindowBeforeClose	Occurs immediately before a Protected View window or a workbook in a Protected View window closes.
SheetPivotTableBeforeDiscardChanges	Occurs before changes to a PivotTable are discarded.
SheetPivotTableAfterValueChange	Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
SheetPivotTableBeforeAllocateChanges	Occurs before changes are applied to a PivotTable.
WorkbookNewChart	Occurs when a new chart is created in any open workbook.
ProtectedViewWindowOpen	Occurs when a workbook is opened in a Protected View window.
ProtectedViewWindowBeforeEdit	Occurs immediately before editing is enabled on the workbook in the specified Protected View window.
ProtectedViewWindowResize	Occurs when any Protected View window is resized.
ProtectedViewWindowDeactivate	Occurs when a Protected View window is deactivated.
WorkbookAfterSave	Occurs after the workbook is saved.

AxisTitle

Properties	Description
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height	Returns the height, in points, of the object. Read-only.
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
Width	Returns the width, in points, of the object. Read-only.

CalculatedMember

Properties	Description
Dynamic	Returns whether the specified named set is recalculated with every update. Read-only
FlattenHierarchies	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
HierarchizeDistinct	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
DisplayFolder	Returns the display folder name for a named set. Read-only

Chart

Properties	Description
PrintedCommentPages	Returns the number of comment pages that will be printed for the current chart. Read-only
ShowLegendFieldButtons	Returns or sets whether to display legend field buttons on a PivotChart. Read/write
ShowValueFieldButtons	Returns or sets whether to display the value field buttons on a PivotChart. Read/write
ShowReportFilterFieldButtons	Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write
ShowAllFieldButtons	Returns or sets whether to display all field buttons on a PivotChart. Read/write
ShowAxisFieldButtons	Returns or sets whether to display axis field buttons on a PivotChart. Read/write

ChartArea

Properties	Description
RoundedCorners	True if the chart area of the chart has rounded corners. Read/write Boolean.

ChartTitle

Properties	Description
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
Height	Returns the height, in points, of the object. Read-only.
Width	Returns the width, in points, of the object. Read-only.

ColorFormat

Properties	Description
Brightness	Returns or sets the luminosity of the specified object. Read/write

CubeField

Properties	Description
HierarchizeDistinct	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
FlattenHierarchies	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

Databar

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

DataLabel

Properties	Description
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height	Returns the height, in points, of the object. Read-only.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
Width	Returns the width, in points, of the object. Read-only.
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.

DisplayUnitLabel

Properties	Description
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height	Returns the height, in points, of the object. Read-only.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
Width	Returns the width, in points, of the object. Read-only.

FillFormat

Properties	Description
PictureEffects	Returns an object that represents the picture or texture fill for the specified fill format. Read-only
GradientAngle	Returns or sets the angle of the gradient fill for the specified fill format. Read/write

IconCriterion

Properties	Description
Icon	Returns or specifies the icon for a criterion in an icon set conditional formatting rule. Read/write

LineFormat

Properties	Description
InsetPen	Returns or sets whether lines are drawn inside the specified shape's boundaries. Read/write

ListObject

Properties	Description
AlternativeText	Returns or sets the descriptive (alternative) text string for the specified table. Read/write
Summary	Returns or sets the description associated with the alternative text string for the specified table. Read/write

OLEDBConnection

Properties	Description
LocaleID	Returns or sets the locale identifier for the specified connection. Read/write
CalculatedMembers	Returns the CalculatedMembers collection for the specified connection. Read-only

Methods	Description
Reconnect	Drops and then reconnects the specified connection.

PictureFormat

Properties	Description
Crop	Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Read-only

PivotCell

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

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

PivotField

Properties	Description
RepeatLabels	Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write

PivotTable

Properties	Description
ShowValuesRow	Returns or sets whether the values row is displayed. Read/write
AllocationMethod	Returns or sets what method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
EnableWriteback	Returns or sets whether writing back to the data source is enabled for the specified PivotTable. The default value is False. Read/write.
AlternativeText	Returns or sets the descriptive (alternative) text string for the specified PivotTable. Read/write
Slicers	Returns the Slicers collection for the specified PivotTable. Read-only
VisualTotalsForSets	Returns or sets whether to include filtered items in the totals of named sets for the specified PivotTable. Read/write
AllocationValue	Returns or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
ChangeList	Returns the PivotTableChangeList collection that represents the list of changes that have been made to the specified PivotTable based on an OLAP data source. Read-only
AllocationWeightExpression	Returns or sets the MDX weight expression to use when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
Summary	Returns or sets the description associated with the alternative text string for the specified table. Read/write
Allocation	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 what-if analysis on a PivotTable based on an OLAP data source. Read/write
CalculatedMembersInFilters	Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write

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

Point

Properties	Description
Width	Returns the width, in points, of the object. Read-only.
Name	Returns the object name. Read-only.
Top	Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Read-only.
Height	Returns the height, in points, of the object. Read-only.
Left	Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only.

Methods	Description
PieSliceLocation	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.

Range

Properties	Description
SparklineGroups	Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Read-only
DisplayFormat	Returns a DisplayFormat object that represents the display settings for the specified range. Read-only

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

Series

Properties	Description
InvertColorIndex	Returns or sets the fill color for negative data points in a series. Read/write
InvertColor	Returns or sets the fill color for negative data points in a series. Read/write
PlotColorIndex	Returns an index value that is used internally to associate series formatting with chart elements. Read-only

Shape

Properties	Description
SmartArt	Returns an object that represents the SmartArt associated with the shape. Read-only
Title	Returns or sets the title of the alternative text associated with the specified shape. Read/write
HasSmartArt	Returns whether there is a SmartArt diagram present on the specified shape. Read-only

ShapeRange

Properties	Description
Title	Returns or sets the title of the alternative text associated with the specified shape range. Read/write

Shapes

Methods	Description
AddSmartArt	Creates a new SmartArt graphic with the specified layout.

SpellingOptions

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

TableStyle

Properties	Description
ShowAsAvailableSlicerStyle	Returns or sets if the specified table style is shown as available in the slicer styles gallery. Read/write

TextFrame

Properties	Description
HorizontalOverflow	Returns or sets the horizontal overflow setting for the specified object. Read/write
VerticalOverflow	Returns or sets the vertical overflow setting for the specified object. Read/write

TextFrame2

Properties	Description
NoTextRotation	Returns or sets whether text remains flat when the specified object is rotated. Read/write

Workbook

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

Methods	Description
CheckInWithVersion	Saves a workbook to a server from a local computer, and sets the local workbook to read-only so that it cannot be edited locally.

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

Worksheet

Properties	Description
PrintedCommentPages	Returns the number of comment pages that will be printed for the current worksheet. Read-only

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

WorksheetFunction

Methods	Description
GammaLn_Precise	Returns the natural logarithm of the gamma function, Γ(x).
Erf_Precise	Returns the error function integrated between zero and lower_limit.
StDev_S	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).
Var_P	Calculates variance based on the entire population.
F_Inv_RT	Returns the inverse of the right-tailed F probability distribution. If p = F_DIST_RT(x,...), then F_INV_RT(p,...) = x.
NegBinom_Dist	Returns the negative binomial distribution. NEGBINOM_DIST returns the probability that there will be number_f failures before the number_s-th 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.
PercentRank_Exc	Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
WorkDay_Intl	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.
Var_S	Estimates variance based on a sample.
Gamma_Dist	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.
ISO_Ceiling	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
ChiSq_Dist	Returns the chi-squared distribution.
Covariance_S	Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
LogNorm_Dist	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.
Confidence_Norm	Returns a value that you can use to construct a confidence interval for a population mean.
ChiSq_Dist_RT	Returns the right-tailed probability of the chi-squared distribution.
T_Dist_2T	Returns the two-tailed Student t-distribution.
Rank_Eq	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.)
PercentRank_Inc	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.
Mode_Sngl	Returns the most frequently occurring, or repetitive, value in an array or range of data.
Beta_Dist	Returns the beta cumulative distribution function.
Binom_Dist	Returns the individual term binomial distribution probability.
T_Inv	Returns the left-tailed inverse of the Student t-distribution.
ChiSq_Inv	Returns the inverse of the left-tailed probability of the chi-squared distribution.
Ceiling_Precise	Returns the specified number rounded to the nearest multiple of significance.
Norm_S_Dist	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.
Percentile_Inc	Returns the k-th 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.
Aggregate	Returns an aggregate in a list or database.
Rank_Avg	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.
F_Dist_RT	Returns the right-tailed 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.
NetworkDays_Intl	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.
T_Dist_RT	Returns the right-tailed Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.
Beta_Inv	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.
Covariance_P	Returns population covariance, the average of the products of deviations for each data point pair.
Poisson_Dist	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.
F_Dist	Returns the F probability distribution.
Quartile_Inc	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.
T_Inv_2T	Returns the t-value of the Student t-distribution as a function of the probability and the degrees of freedom.
F_Inv	Returns the inverse of the F probability distribution.
Floor_Precise	Rounds the specified number to the nearest multiple of significance.
Norm_Inv	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
LogNorm_Inv	Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.
Mode_Mult	Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data.
ErfC_Precise	Returns the complementary error function integrated between the specified value and infinity.
Quartile_Exc	Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
Norm_Dist	Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.
Percentile_Exc	Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Confidence_T	Returns the confidence interval for a population mean, using a Student's t distribution.
Gamma_Inv	Returns the inverse of the gamma cumulative distribution. If p = GAMMA_DIST(x,...), then GAMMA_INV(p,...) = x.
Binom_Inv	Returns the inverse of the individual term binomial distribution probability.
HypGeom_Dist	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.
Z_Test	Returns the one-tailed probability-value of a z-test. 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.
Expon_Dist	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.
F_Test	Returns the result of an F-test. An F-test returns the two-tailed 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.
StDev_P	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).
T_Test	Returns the probability associated with a Student t-Test. Use T_TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.
ChiSq_Inv_RT	Returns the inverse of the right-tailed probability of the chi-squared distribution.
Weibull_Dist	Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device.
T_Dist	Returns a Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are computed.
ChiSq_Test	Returns the test for independence.
Norm_S_Inv	Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.

New Constants

The following constants have been added to existing enumerations in Microsoft Excel 2010.

Enumeration	New Constants
XlBuiltInDialog	xlDialogPivotTableSlicerConnections xlDialogPivotTableWhatIfAnalysisSettings xlDialogSetManager xlDialogSetMDXEditor xlDialogSetTupleEditorOnColumns xlDialogSetTupleEditorOnRows xlDialogSlicerCreation xlDialogSlicerPivotTableConnections xlDialogSlicerSettings xlDialogSparklineInsertColumn xlDialogSparklineInsertLine xlDialogSparklineInsertWinLoss
XlConditionValueTypes	xlConditionValueAutomaticMax xlConditionValueAutomaticMin
XlFileFormat	xlOpenDocumentSpreadsheet
XlIconSet	xl3Stars xl3Triangles xl5Boxes xlCustomSet
XlPivotFieldCalculation	xlPercentOfParent xlPercentOfParentColumn xlPercentOfParentRow xlPercentRunningTotal xlRankAscending xlRankDecending
XlPivotTableVersionList	xlPivotTableVersion14
XlTableStyleElementType	xlSlicerHoveredSelectedItemWithData xlSlicerHoveredSelectedItemWithNoData xlSlicerHoveredUnselectedItemWithData xlSlicerHoveredUnselectedItemWithNoData xlSlicerSelectedItemWithData xlSlicerSelectedItemWithNoData xlSlicerUnselectedItemWithData xlSlicerUnselectedItemWithNoData

New Members

The following properties, methods, and events have been added to existing objects in Microsoft Excel 2010.

AddIn

Properties	Description
IsOpen	Returns True if the add-in is currently open. Boolean Read-only

Application

Properties	Description
SaveISO8601Dates	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.
FileValidation	Returns or sets how Excel will validate files before opening them. Read/write
ProtectedViewWindows	Returns a ProtectedViewWindows collection that represents all the Protected View windows that are open in the application. Read-only
FileExportConverters	Returns a FileExportConverters collection that represents all the file converters for saving files available to Microsoft Excel. Read-only.
HinstancePtr	Returns a handle to the instance of Microsoft Excel 2010 represented by the Application object. Read-only Variant.
FileValidationPivot	Returns or sets how Excel will validate the contents of the data caches for PivotTable reports. Read/write
SmartArtLayouts	Returns the set of SmartArt layouts that are currently loaded in the application. Read-only
AddIns2	Returns an AddIns2 collection that represents all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed. Read-only
HighQualityModeForGraphics	Returns or sets whether Excel uses high quality mode to print graphics. Read/write
ActiveProtectedViewWindow	Returns a ProtectedViewWindow object that represents the active Protected View window (the window on top). Read-only. Returns Nothing if there are no Protected View windows open. Read-only
PrintCommunication	Specifies whether communication with the printer is turned on. Boolean Read/write
SmartArtColors	Returns the set of color styles that are currently loaded in the application. Read-only
IsSandboxed	Returns True if the specified workbook is open in a Protected View window. Read-only
SmartArtQuickStyles	Returns the set of SmartArt quick styles which are currently loaded in the application. Read-only
UseClusterConnector	Returns or sets whether Excel allows user-defined functions in XLL add-ins to be run on a compute cluster. Read/write
ClusterConnector	Returns or sets the name of the High Performance Computing (HPC) Cluster Connector that is used to run user-defined functions in XLL add-ins. Read/write

Events	Description
ProtectedViewWindowActivate	Occurs when a Protected View window is activated.
SheetPivotTableBeforeCommitChanges	Occurs before changes are committed against the OLAP data source for a PivotTable.
ProtectedViewWindowBeforeClose	Occurs immediately before a Protected View window or a workbook in a Protected View window closes.
SheetPivotTableBeforeDiscardChanges	Occurs before changes to a PivotTable are discarded.
SheetPivotTableAfterValueChange	Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
SheetPivotTableBeforeAllocateChanges	Occurs before changes are applied to a PivotTable.
WorkbookNewChart	Occurs when a new chart is created in any open workbook.
ProtectedViewWindowOpen	Occurs when a workbook is opened in a Protected View window.
ProtectedViewWindowBeforeEdit	Occurs immediately before editing is enabled on the workbook in the specified Protected View window.
ProtectedViewWindowResize	Occurs when any Protected View window is resized.
ProtectedViewWindowDeactivate	Occurs when a Protected View window is deactivated.
WorkbookAfterSave	Occurs after the workbook is saved.

AxisTitle

Properties	Description
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height	Returns the height, in points, of the object. Read-only.
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
Width	Returns the width, in points, of the object. Read-only.

CalculatedMember

Properties	Description
Dynamic	Returns whether the specified named set is recalculated with every update. Read-only
FlattenHierarchies	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
HierarchizeDistinct	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
DisplayFolder	Returns the display folder name for a named set. Read-only

Chart

Properties	Description
PrintedCommentPages	Returns the number of comment pages that will be printed for the current chart. Read-only
ShowLegendFieldButtons	Returns or sets whether to display legend field buttons on a PivotChart. Read/write
ShowValueFieldButtons	Returns or sets whether to display the value field buttons on a PivotChart. Read/write
ShowReportFilterFieldButtons	Returns or sets whether to display the report filter field buttons on a PivotChart. Read/write
ShowAllFieldButtons	Returns or sets whether to display all field buttons on a PivotChart. Read/write
ShowAxisFieldButtons	Returns or sets whether to display axis field buttons on a PivotChart. Read/write

ChartArea

Properties	Description
RoundedCorners	True if the chart area of the chart has rounded corners. Read/write Boolean.

ChartTitle

Properties	Description
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
Height	Returns the height, in points, of the object. Read-only.
Width	Returns the width, in points, of the object. Read-only.

ColorFormat

Properties	Description
Brightness	Returns or sets the luminosity of the specified object. Read/write

CubeField

Properties	Description
HierarchizeDistinct	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
FlattenHierarchies	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

Databar

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

DataLabel

Properties	Description
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height	Returns the height, in points, of the object. Read-only.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
Width	Returns the width, in points, of the object. Read-only.
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.

DisplayUnitLabel

Properties	Description
Formula	Gets or sets a String value that represents the formula of the object using A1-style notation, in English. Read/write.
FormulaR1C1	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in English. Read/write.
FormulaLocal	Gets or sets a String value that represents the formula of the object using A1-style notation, in the language of the user. Read/write.
Height	Returns the height, in points, of the object. Read-only.
FormulaR1C1Local	Gets or sets a String value that represents the formula of the object using R1C1-style notation, in the language of the user. Read/write.
Width	Returns the width, in points, of the object. Read-only.

FillFormat

Properties	Description
PictureEffects	Returns an object that represents the picture or texture fill for the specified fill format. Read-only
GradientAngle	Returns or sets the angle of the gradient fill for the specified fill format. Read/write

IconCriterion

Properties	Description
Icon	Returns or specifies the icon for a criterion in an icon set conditional formatting rule. Read/write

LineFormat

Properties	Description
InsetPen	Returns or sets whether lines are drawn inside the specified shape's boundaries. Read/write

ListObject

Properties	Description
AlternativeText	Returns or sets the descriptive (alternative) text string for the specified table. Read/write
Summary	Returns or sets the description associated with the alternative text string for the specified table. Read/write

OLEDBConnection

Properties	Description
LocaleID	Returns or sets the locale identifier for the specified connection. Read/write
CalculatedMembers	Returns the CalculatedMembers collection for the specified connection. Read-only

Methods	Description
Reconnect	Drops and then reconnects the specified connection.

PictureFormat

Properties	Description
Crop	Returns an Crop object that represents the cropping settings for the specified PictureFormat object. Read-only

PivotCell

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

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

PivotField

Properties	Description
RepeatLabels	Returns or sets whether item labels are repeated in the PivotTable for the specified PivotField. Read/write

PivotTable

Properties	Description
ShowValuesRow	Returns or sets whether the values row is displayed. Read/write
AllocationMethod	Returns or sets what method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
EnableWriteback	Returns or sets whether writing back to the data source is enabled for the specified PivotTable. The default value is False. Read/write.
AlternativeText	Returns or sets the descriptive (alternative) text string for the specified PivotTable. Read/write
Slicers	Returns the Slicers collection for the specified PivotTable. Read-only
VisualTotalsForSets	Returns or sets whether to include filtered items in the totals of named sets for the specified PivotTable. Read/write
AllocationValue	Returns or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
ChangeList	Returns the PivotTableChangeList collection that represents the list of changes that have been made to the specified PivotTable based on an OLAP data source. Read-only
AllocationWeightExpression	Returns or sets the MDX weight expression to use when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write
Summary	Returns or sets the description associated with the alternative text string for the specified table. Read/write
Allocation	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 what-if analysis on a PivotTable based on an OLAP data source. Read/write
CalculatedMembersInFilters	Returns or sets whether to evaluate calculated members from OLAP servers in filters. Read/write

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

Point

Properties	Description
Width	Returns the width, in points, of the object. Read-only.
Name	Returns the object name. Read-only.
Top	Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Read-only.
Height	Returns the height, in points, of the object. Read-only.
Left	Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only.

Methods	Description
PieSliceLocation	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.

Range

Properties	Description
SparklineGroups	Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Read-only
DisplayFormat	Returns a DisplayFormat object that represents the display settings for the specified range. Read-only

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

Series

Properties	Description
InvertColorIndex	Returns or sets the fill color for negative data points in a series. Read/write
InvertColor	Returns or sets the fill color for negative data points in a series. Read/write
PlotColorIndex	Returns an index value that is used internally to associate series formatting with chart elements. Read-only

Shape

Properties	Description
SmartArt	Returns an object that represents the SmartArt associated with the shape. Read-only
Title	Returns or sets the title of the alternative text associated with the specified shape. Read/write
HasSmartArt	Returns whether there is a SmartArt diagram present on the specified shape. Read-only

ShapeRange

Properties	Description
Title	Returns or sets the title of the alternative text associated with the specified shape range. Read/write

Shapes

Methods	Description
AddSmartArt	Creates a new SmartArt graphic with the specified layout.

SpellingOptions

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

TableStyle

Properties	Description
ShowAsAvailableSlicerStyle	Returns or sets if the specified table style is shown as available in the slicer styles gallery. Read/write

TextFrame

Properties	Description
HorizontalOverflow	Returns or sets the horizontal overflow setting for the specified object. Read/write
VerticalOverflow	Returns or sets the vertical overflow setting for the specified object. Read/write

TextFrame2

Properties	Description
NoTextRotation	Returns or sets whether text remains flat when the specified object is rotated. Read/write

Workbook

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

Methods	Description
CheckInWithVersion	Saves a workbook to a server from a local computer, and sets the local workbook to read-only so that it cannot be edited locally.

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

Worksheet

Properties	Description
PrintedCommentPages	Returns the number of comment pages that will be printed for the current worksheet. Read-only

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

WorksheetFunction

Methods	Description
GammaLn_Precise	Returns the natural logarithm of the gamma function, Γ(x).
Erf_Precise	Returns the error function integrated between zero and lower_limit.
StDev_S	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).
Var_P	Calculates variance based on the entire population.
F_Inv_RT	Returns the inverse of the right-tailed F probability distribution. If p = F_DIST_RT(x,...), then F_INV_RT(p,...) = x.
NegBinom_Dist	Returns the negative binomial distribution. NEGBINOM_DIST returns the probability that there will be number_f failures before the number_s-th 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.
PercentRank_Exc	Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
WorkDay_Intl	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.
Var_S	Estimates variance based on a sample.
Gamma_Dist	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.
ISO_Ceiling	Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance.
ChiSq_Dist	Returns the chi-squared distribution.
Covariance_S	Returns the sample covariance, the average of the products of deviations for each data point pair in two data sets.
LogNorm_Dist	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.
Confidence_Norm	Returns a value that you can use to construct a confidence interval for a population mean.
ChiSq_Dist_RT	Returns the right-tailed probability of the chi-squared distribution.
T_Dist_2T	Returns the two-tailed Student t-distribution.
Rank_Eq	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.)
PercentRank_Inc	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.
Mode_Sngl	Returns the most frequently occurring, or repetitive, value in an array or range of data.
Beta_Dist	Returns the beta cumulative distribution function.
Binom_Dist	Returns the individual term binomial distribution probability.
T_Inv	Returns the left-tailed inverse of the Student t-distribution.
ChiSq_Inv	Returns the inverse of the left-tailed probability of the chi-squared distribution.
Ceiling_Precise	Returns the specified number rounded to the nearest multiple of significance.
Norm_S_Dist	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.
Percentile_Inc	Returns the k-th 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.
Aggregate	Returns an aggregate in a list or database.
Rank_Avg	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.
F_Dist_RT	Returns the right-tailed 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.
NetworkDays_Intl	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.
T_Dist_RT	Returns the right-tailed Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed. The t-distribution is used in the hypothesis testing of small sample data sets. Use this function in place of a table of critical values for the t-distribution.
Beta_Inv	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.
Covariance_P	Returns population covariance, the average of the products of deviations for each data point pair.
Poisson_Dist	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.
F_Dist	Returns the F probability distribution.
Quartile_Inc	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.
T_Inv_2T	Returns the t-value of the Student t-distribution as a function of the probability and the degrees of freedom.
F_Inv	Returns the inverse of the F probability distribution.
Floor_Precise	Rounds the specified number to the nearest multiple of significance.
Norm_Inv	Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
LogNorm_Inv	Returns the inverse of the lognormal cumulative distribution function. Use the lognormal distribution to analyze logarithmically transformed data.
Mode_Mult	Returns a vertical array of the most frequently occurring, or repetitive, values in an array or range of data.
ErfC_Precise	Returns the complementary error function integrated between the specified value and infinity.
Quartile_Exc	Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
Norm_Dist	Returns the normal distribution for the specified mean and standard deviation. This function has a wide range of applications in statistics, including hypothesis testing.
Percentile_Exc	Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.
Confidence_T	Returns the confidence interval for a population mean, using a Student's t distribution.
Gamma_Inv	Returns the inverse of the gamma cumulative distribution. If p = GAMMA_DIST(x,...), then GAMMA_INV(p,...) = x.
Binom_Inv	Returns the inverse of the individual term binomial distribution probability.
HypGeom_Dist	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.
Z_Test	Returns the one-tailed probability-value of a z-test. 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.
Expon_Dist	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.
F_Test	Returns the result of an F-test. An F-test returns the two-tailed 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.
StDev_P	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).
T_Test	Returns the probability associated with a Student t-Test. Use T_TEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.
ChiSq_Inv_RT	Returns the inverse of the right-tailed probability of the chi-squared distribution.
Weibull_Dist	Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating the mean time to failure for a device.
T_Dist	Returns a Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are computed.
ChiSq_Test	Returns the test for independence.
Norm_S_Inv	Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of 0 (zero) and a standard deviation of one.

New Constants

The following constants have been added to existing enumerations in Microsoft Excel 2010.

Enumeration	New Constants
XlBuiltInDialog	xlDialogPivotTableSlicerConnections xlDialogPivotTableWhatIfAnalysisSettings xlDialogSetManager xlDialogSetMDXEditor xlDialogSetTupleEditorOnColumns xlDialogSetTupleEditorOnRows xlDialogSlicerCreation xlDialogSlicerPivotTableConnections xlDialogSlicerSettings xlDialogSparklineInsertColumn xlDialogSparklineInsertLine xlDialogSparklineInsertWinLoss
XlConditionValueTypes	xlConditionValueAutomaticMax xlConditionValueAutomaticMin
XlFileFormat	xlOpenDocumentSpreadsheet
XlIconSet	xl3Stars xl3Triangles xl5Boxes xlCustomSet
XlPivotFieldCalculation	xlPercentOfParent xlPercentOfParentColumn xlPercentOfParentRow xlPercentRunningTotal xlRankAscending xlRankDecending
XlPivotTableVersionList	xlPivotTableVersion14
XlTableStyleElementType	xlSlicerHoveredSelectedItemWithData xlSlicerHoveredSelectedItemWithNoData xlSlicerHoveredUnselectedItemWithData xlSlicerHoveredUnselectedItemWithNoData xlSlicerSelectedItemWithData xlSlicerSelectedItemWithNoData xlSlicerUnselectedItemWithData xlSlicerUnselectedItemWithNoData