Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
New Members and Constants_Excel.Dev

New Members and Constants_Excel.Dev

Office 2010

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

Properties

Description

IsOpen

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

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.

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.

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

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

Properties

Description

RoundedCorners

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

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.

Properties

Description

Brightness

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

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

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

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.

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.

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

Properties

Description

Icon

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

Properties

Description

InsetPen

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

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

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.

Properties

Description

Crop

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

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.

Properties

Description

RepeatLabels

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

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.

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.

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.

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

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

Properties

Description

Title

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

Methods

Description

AddSmartArt

Creates a new SmartArt graphic with the specified layout.

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

Properties

Description

ShowAsAvailableSlicerStyle

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

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

Properties

Description

NoTextRotation

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

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.

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).

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.

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

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

Properties

Description

IsOpen

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

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.

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.

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

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

Properties

Description

RoundedCorners

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

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.

Properties

Description

Brightness

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

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

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

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.

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.

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

Properties

Description

Icon

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

Properties

Description

InsetPen

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

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

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.

Properties

Description

Crop

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

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.

Properties

Description

RepeatLabels

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

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.

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.

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.

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

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

Properties

Description

Title

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

Methods

Description

AddSmartArt

Creates a new SmartArt graphic with the specified layout.

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

Properties

Description

ShowAsAvailableSlicerStyle

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

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

Properties

Description

NoTextRotation

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

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.

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).

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.

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

Show:
© 2015 Microsoft