New Objects in 2007
| AboveAverage (new) | |
| Object | |
| Action (new) | |
| Object | |
| Actions (new) | |
| Object | |
| Application | |
| ShowDevTools (Property) | Returns or sets a Boolean that represents whether the Developer tab is displayed in the Ribbon. Read/write Boolean. |
| ShowMenuFloaties (Property) | Returns or sets a Boolean that represents whether to display Mini toolbars when the user right-clicks in the workbook window. Read/write Boolean. |
| ShowSelectionFloaties (Property) | Returns or sets a Boolean that represents whether Mini toolbars displays when a user selects text. Read/write Boolean. |
| WarnOnFunctionNameConflict (Property) | The WarnOnFunctionNameConflict property, when set to True, raises an alert if a developer tries to create a new function using an existing function name. Read/write Boolean. |
| LargeOperationCellThousandCount (Property) | Returns or sets the maximum number of cells needed in an operation beyond which an alert is triggered. Read/write Long. |
| MeasurementUnit (Property) | Specifies the measurement unit used in the application. Read/write xlMeasurementUnit. |
| MultiThreadedCalculation (Property) | Returns a MultiThreadedCalculation object that controls the multi-threaded recalculation settings that are new in Excel 2007. Read-only. |
| DeferAsyncQueries (Property) | Gets or sets whether asychronous queries to OLAP data sources are executed when a worksheet is calculated by VBA code. Read/write Boolean. |
| DisplayDocumentInformationPanel (Property) | Returns or sets a Boolean that represents whether the document properties panel is displayed. Read/write Boolean. |
| DisplayFormulaAutoComplete (Property) | Gets or sets whether to show a list of relevant functions and defined names when building cell formulas. Read/write Boolean. |
| EnableLargeOperationAlert (Property) | Sets or returns a Boolean that represents whether to display an alert message when a user attempts to perform an operation that affects a larger number of cells than is specified in the Office center UI. Read/write Boolean. |
| EnableLivePreview (Property) | Sets or returns a Boolean that represents whether to show or hide gallery previews that appear when using galleries that support previewing. Setting this property to True shows a preview of your workbook before applying the command. Read/write Boolean. |
| FormulaBarHeight (Property) | Allows the user to specify the height of the formula bar in lines. Read/write Long. |
| GenerateTableRefs (Property) | The GenerateTableRefs property determines whether the traditional notation method or the new structured referencing notation method is used for referencing tables in formulas. Read/write. |
| ActiveEncryptionSession (Property) | Read-only |
| AlwaysUseClearType (Property) | Returns or sets a Boolean that represents whether to use ClearType to display fonts in the menu, Ribbon, and dialog box text. Read/write Boolean. |
| Assistance (Property) | Returns an IAssistance object for Excel 2007 that represents the Microsoft Office Help Viewer. Read-only. |
| SharePointVersion (Method) | |
| CalculateUntilAsyncQueriesDone (Method) | Runs all pending queries to OLEDB and OLAP data sources. |
| AutoCorrect | |
| AutoFillFormulasInLists (Property) | Affects the creation of calculated columns created by automatic fill-down lists. Read/write Boolean. |
| AutoFilter | |
| Sort (Property) | Gets the sort column or columns, and sort order for the AutoFilter collection. |
| FilterMode (Property) | Returns True if the worksheet is in the AutoFilter filter mode. Read-only Boolean. |
| ShowAllData (Method) | Displays all the data returned by the AutoFilter object. |
| ApplyFilter (Method) | Applies the specified Autofilter object. |
| Axis | |
| LogBase (Property) | Returns or sets the base of the logarithm when you are using log scales. Read/write Double. |
| TickLabelSpacingIsAuto (Property) | Returns or sets whether or not the tick label spacing is automatic. Read/write Boolean. |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| AxisTitle | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| IncludeInLayout (Property) | True if an axis title will occupy the chart layout space when a chart layout is being determined. The default value is True. Read/write Boolean. |
| Position (Property) | Returns or sets the position of the axis title on the chart. Read/write xlChartElementPosition |
| Border | |
| ThemeColor (Property) | Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Variant. |
| TintAndShade (Property) | Returns or sets a Single that lightens or darkens a color. |
| Borders | |
| ThemeColor (Property) | Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Variant. |
| TintAndShade (Property) | Returns or sets a Single that lightens or darkens a color. |
| Chart | |
| ShowDataLabelsOverMaximum (Property) | Returns or sets whether to show the data labels when the value is greater than the maximum value on the value axis. Read/write Boolean. |
| SideWall (Property) | Returns a Walls object that allows the user to individually format the side wall of a 3-D chart. Read-only. |
| BackWall (Property) | Returns a Walls object that allows the user to individually format the back wall of a 3-D chart. Read-only. |
| ChartStyle (Property) | Returns or sets the chart style for the chart. Read/write Variant. |
| ApplyChartTemplate (Method) | Applies a standard or custom chart type to a chart. |
| ApplyLayout (Method) | Applies the layouts shown in the ribbon. |
| ExportAsFixedFormat (Method) | Exports to a file of the specified format. |
| SaveChartTemplate (Method) | Saves a custom chart template to the list of available chart templates. |
| SetDefaultChart (Method) | Specifies the name of the chart template that Microsoft Excel uses when creating new charts. |
| SetElement (Method) | Sets chart elements on a chart. Read/write msoChartElementType |
| ClearToMatchStyle (Method) | Clears the chart elements formatting to automatic. |
| ChartArea | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| ChartFormat (new) | |
| (Object) | Provides access to the Office Art formatting for chart elements. |
| ChartObjects | |
| ProtectChartObject (Property) | True if the embedded chart frame cannot be moved, resized, or deleted through the user interface. Read/write Boolean. |
| ChartTitle | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Position (Property) | Returns or sets the position of the chart title on the chart. Read/write xlChartElementPosition |
| IncludeInLayout (Property) | True if a chart title will occupy the chart layout space when a chart layout is being determined. The default value is True. Read/write Boolean. |
| ChartView (new) | |
| (Object) | Represents a view of a chart. |
| ColorFormat | |
| ObjectThemeColor (Property) | Returns or sets a color that is mapped to the theme color scheme. Read/write msoThemeColorIndex. |
| ColorScale (new) | |
| (Object) | Represents a color scale conditional formatting rule. |
| ColorScaleCriteria (new) | |
| (Object) | A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale. |
| ColorScaleCriterion (new) | |
| (Object) | Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format. |
| ColorStop (new) | |
| (Object) | Represents the color stop point for a gradient fill in a range or selection. |
| ColorStops (new) | |
| (Object) | Represents a collection of colorstops. |
| ConditionValue (new) | |
| (Object) | Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule. |
| Connections (new) | |
| (Object) | This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
| CubeField | |
| AllItemsVisible (Property) | The AllItemsVisible property checks whether manual filtering is applied to a PivotField or CubeField. Read-only Boolean. |
| CubeFieldSubType (Property) | Specifies the type of a CubeField. Read-only. |
| CurrentPageName (Property) | Returns or sets the page name for a CubeField. Read/write String. |
| IncludeNewItemsInFilter (Property) | The IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables. Read/write. |
| IsDate (Property) | Returns True if the CubeField is a date. Read-only Boolean. |
| ClearManualFilter (Method) | The ClearManualFilter method provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList/VisibleItemsList collections in OLAP PivotTables. |
| CreatePivotFields (Method) | The CreatePivotFields method is new in Microsoft Office Excel 2007. It enables users to apply a filter to PivotFields not yet added to the PivotTable by creating the corresponding PivotField object. |
| Databar (new) | Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells. |
| (Object) | |
| DataLabel | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| DataLabels | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| DataTable | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| DialogSheetView (new) | |
| (Object) | |
| DisplayUnitLabel | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Position (Property) | Returns or sets the position of the unit label on an axis in the chart. Read/write xlChartElementPosition |
| DownBars | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| DropLines | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| ErrorBars | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| ErrorCheckingOptions | |
| InconsistentTableFormula (Property) | Returns True if the table formula is inconsistent. Read/write Boolean. |
| FillFormat | |
| GradientStops (Property) | Returns the end point for the gradient fill. Read-only. |
| TextureOffsetX (Property) | Returns the offset X value for the specified fill. Read/write Single. |
| TextureOffsetY (Property) | Returns the offset Y value for the specified fill. Read/write Single. |
| TextureTile (Property) | Returns the texture tile style for the specified fill. Read/write MsoTriState. |
| RotateWithObject (Property) | Returns or sets if the fill style should rotate with the object. Read/write msoTriState |
| TextureAlignment (Property) | Returns or sets the text alignment for the specified FillFormat object. Read/write. |
| TextureHorizontalScale (Property) | Returns or sets the value for horizontally scaling the text for the FillFormat object. Read/write Single. |
| TextureVerticalScale (Property) | Returns the texture vertical scale for the specified fill. Read/write Single. |
| Filter | |
| Count (Property) | Returns the number of objects in the collection. Read-only Long. |
| Floor | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Thickness (Property) | Returns or sets a Long, specifying the thickness of the floor. Read/write. |
| Font | |
| ThemeColor (Property) | Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Variant. |
| ThemeFont (Property) | Returns or sets the theme font in the applied font scheme that is associated with the specified object. Read/write xlThemeFont. |
| TintAndShade (Property) | Returns or sets a Single that lightens or darkens a color. |
| FormatColor (new) | Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format. |
| FormatCondition | |
| NumberFormat (Property) | Returns or sets the number format applied to a cell if the conditional formatting rule evaluates to True. Read/write Variant. |
| Priority (Property) | Returns or sets the priority value of the conditional formatting rule. The priority determines the order of evaluation when multiple conditional formatting rules exist in a worksheet. |
| PTCondition (Property) | Returns a Boolean value indicating if the conditional format is being applied to a PivotTable chart. Read-only. |
| ScopeType (Property) | Returns or sets one of the constants of the xlPivotConditionScope. enumeration, which determines the scope of the conditional format when it is applied to a PivotTable chart. |
| StopIfTrue (Property) | Returns or sets a Boolean value that determines if additional formatting rules on the cell should be evaluated if the current rule evaluates to True. |
| Text (Property) | Returns or sets a String value specifying the text string used by the conditional formatting rule. |
| TextOperator (Property) | Returns or sets one of the constants of the xlContainsOperator enumeration, specifying the text search performed by the conditional formatting rule. |
| AppliesTo (Property) | Returns a Range object specifying the cell range to which the formatting rule is applied. |
| DateOperator (Property) | Specifies the Date operator used in the format condition. Read/write. |
| FormatRow (Property) | Returns or sets a Boolean value specifying if the entire Excel table row should be formatted if the conditional format rule evaluates to True. The default value is False. |
| ModifyAppliesToRange (Method) | Sets the cell range to which this formatting rule applies. |
| SetFirstPriority (Method) | Sets the priority value for this conditional formatting rule to "1" so that it will be evaluated before all other rules on the worksheet. |
| SetLastPriority (Method) | Sets the evaluation order for this conditional formatting rule so it is evaluated after all other rules on the worksheet. |
| FormatConditions | |
| AddAboveAverage (Method) | Returns a new AboveAverage object representing a conditional formatting rule for the specified range. |
| AddColorScale (Method) | Returns a new ColorScale object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range. |
| AddDatabar (Method) | Returns a Databar object representing a data bar conditional formatting rule for the specified range. |
| AddIconSetCondition (Method) | Returns a new IconSetCondition object which represents an icon set conditional formatting rule for the specified range. |
| AddTop10 (Method) | Returns a Top10 object representing a conditional formatting rule for the specified range. |
| AddUniqueValues (Method) | Returns a new UniqueValues object representing a conditional formatting rule for the specified range. |
| Gridlines | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| HeaderFooter (new) | |
| (Object) | Represents a single header or footer. The HeaderFooter object is a member of the HeadersFooters collection. The HeadersFooters collection includes all headers and footers in the specified workbook section. |
| HiLoLines | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Icon (new) | |
| (Object) | Represents a single icon in an icon set used in a conditional formatting rule. |
| IconCriteria (new) | |
| (Object) | Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule. |
| IconCriterion (new) | |
| (Object) | Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule. |
| IconSet (new) | |
| (Object) | Represents a single set of icons that are used in an icon set conditional formatting rule. |
| IconSetCondition (new) | |
| (Object) | Represents an icon set conditional formatting rule. |
| IconSets (new) | |
| (Object) | Represents a collection of icon sets used in an icon set conditional formatting rule. |
| Interior | |
| Gradient (Property) | Returns or sets the Gradient property of an Interior object of a selection. Read-only |
| PatternThemeColor (Property) | Returns or sets a theme color pattern for an Interior object. Read/write Variant. |
| PatternTintAndShade (Property) | Returns or sets a tint and shade pattern for an Interior object. Read/write Variant. |
| ThemeColor (Property) | Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write Variant. |
| TintAndShade (Property) | Returns or sets a Single that lightens or darkens a color. |
| LeaderLines | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Legend | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| IncludeInLayout (Property) | True if a legend will occupy the chart layout space when a chart layout is being determined. The default value is True. Read/write Boolean. |
| LegendEntry | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| LegendKey | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| PictureUnit2 (Property) | Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (?) (if not, this property is ignored). Read/write Double. |
| LinearGradient (new) | |
| (Object) | The LinearGradient object transitions through a series of colors in a linear manner along a specific angle. |
| ListColumn | |
| DataBodyRange (Property) | Returns a Range object that is the size of the data portion of a column. Read-only. |
| Total (Property) | Returns the Total row for a ListColumn object. Read-only. |
| ListObject | |
| ShowHeaders (Property) | Returns or sets if the header information should be displayed for the specified ListObject object. Read/write Boolean. |
| ShowTableStyleColumnStripes (Property) | Returns or sets if the Column Stripes table style is used for the specified ListObject object. Read/write Boolean. |
| ShowTableStyleFirstColumn (Property) | Returns or sets if the first column is displayed for the specified ListObject object. Read/write Boolean. |
| ShowTableStyleLastColumn (Property) | Returns or sets if the last column is displayed for the specified ListObject object. Read/write Boolean. |
| ShowTableStyleRowStripes (Property) | Returns or sets if the Row Stripes table style is used for the specified ListObject object. Read/write Boolean. |
| AutoFilter (Property) | Filters a list using the AutoFilter. Read-only. |
| Comment (Property) | Returns or sets the comment associated with the list object. Read/write String. |
| DisplayName (Property) | Returns or sets the display name for the specified ListObject object. Read/write String. |
| TableStyle (Property) | Gets or sets the table style for the specified ListObject object. Read/write Variant. |
| Sort (Property) | Gets or sets the sort column or columns, and sort order for the ListObject collection. |
| ExportToVisio (Method) | Exports a ListObject object to Visio. |
| ModuleView (new) | |
| MultiThreadedCalculation (new) | Returns or sets the concurrent calculation mode. |
| Application (Property) | |
| Creator (Property) | |
| Enabled (Property) | |
| Parent (Property) | |
| ThreadCount (Property) | |
| ThreadMode (Property) | |
| Name | |
| ValidWorkbookParameter (Property) | Returns True if the specified Name object is a valid workbook parameter. Read-only Boolean. |
| Comment (Property) | Returns or sets the comment associated with the name. Read/write String. |
| WorkbookParameter (Property) | |
| ODBCConnection (new) | Represents the ODBC connection. |
| OLEDBConnection (new) | Represents the OLE DB connection. |
| Page (new) | Represents a page in a workbook. Use the PageSetup object and the related methods and properties for programmatically defining page layout in a workbook. |
| Pages (new) | A collection of pages in a document. Use the Pages collection and the related objects and properties for programmatically defining page layout in a workbook. |
| PageSetup | |
| AlignMarginsHeaderFooter (Property) | Returns True for Excel to align the header and the footer with the margins set in the page setup options. Read/write Boolean. |
| ScaleWithDocHeaderFooter (Property) | Returns or sets if the header and footer should be scaled with the document when the size of the document changes. Read/write Boolean. |
| DifferentFirstPageHeaderFooter (Property) | True if a different header or footer is used on the first page. Read/write Boolean. |
| EvenPage (Property) | Returns or sets the alignment of text on the even page of a workbook or section. |
| FirstPage (Property) | Returns or sets the alignment of text on the first page of a workbook or section. |
| OddAndEvenPagesHeaderFooter (Property) | True if the specified PageSetup object has different headers and footers for odd-numbered and even-numbered pages. Read/write Boolean. |
| Pages (Property) | Returns or sets the the count or item number of the pages in Pages collection. |
| Pane | |
| PointsToScreenPixelsX (Method) | Returns or sets a pixel point on the screen. |
| PointsToScreenPixelsY (Method) | Returns or sets the location of the pixel on the screen. |
| PivotAxis (new) | |
| (Object) | The PivotAxis object is used for asymmetric drilling in a PivotTable. |
| PivotCache | |
| UpgradeOnRefresh (Property) | Contains information on whether to upgrade the PivotCache and all connected PivotTables on the next refresh. Read/write Boolean. |
| Version (Property) | Returns the version of Microsoft Excel in which the PivotCache was created. Read-only. |
| WorkbookConnection (Property) | Establishes a connection between the current workbook and the PivotCache object. Read-only. |
| PivotCaches | |
| Create (Method) | Creates a new PivotCache. |
| PivotCell | |
| PivotColumnLine (Property) | Returns the PivotLine on a column for a specific PivotCell object. Read-only PivotLine. |
| PivotRowLine (Property) | Returns the PivotLine on a row for a specific PivotCell object. Read-only PivotLine. |
| PivotField | |
| AllItemsVisible (Property) | Used to retrieve a Boolean value that indicates whether or not any manual filtering is applied to the PivotField. Read-only. |
| LayoutCompactRow (Property) | Specifies whether or not a PivotField is compacted (items of multiple PivotFields are displayed in a single column) when rows are selected. Read/write Boolean. |
| UseMemberPropertyAsCaption (Property) | This property is used to control whether member property captions are used for PivotItem captions of the PivotField. Read/write Boolean. |
| AutoSortCustomSubtotal (Property) | Returns the name of the custom subtotal used to sort the specified PivotTable field automatically. Read-only. |
| AutoSortPivotLine (Property) | Returns the name of the PivotLine used to sort the specified PivotTable field automatically. Read-only. |
| DisplayAsCaption (Property) | This property is used to display member properties of PivotFields as captions. Read-only. |
| DisplayAsTooltip (Property) | This property is used to specify whether or not a specific member property PivotField is displayed in tooltips. Read/write Boolean. |
| DisplayInReport (Property) | This property is used to specify whether the specified member property PivotField is displayed in the PivotTable or not. Read/write Boolean. |
| EnableMultiplePageItems (Property) | Used for specifying whether or not check boxes are present in the filter drop-down list for fields in the page area. Read/write Boolean. |
| Hidden (Property) | This property is used to hide the individual levels of an OLAP hierarchy. Read/write Boolean. |
| IncludeNewItemsInFilter (Property) | This property allows developers to specify whether excluded or included items should be tracked when manual filtering is applied to the PivotField. Read/write Boolean. |
| MemberPropertyCaption (Property) | Setting the MemberPropertyCaption property controls which member property is used as caption for a given level. Read/write Boolean. |
| PivotFilters (Property) | Returns or sets the PivotFilters for the specified PivotField object. Read-only. |
| ShowDetail (Property) | Gets or sets whether the specified PivotField is showing detail. Read/write Boolean. |
| ShowingInAxis (Property) | Indicates if the PivotField is currently visible in the PivotTable or not. Read-only. |
| SourceCaption (Property) | The SourceCaption property is applicable only for OLAP PivotTables, and returns the original caption from the OLAP server for a PivotField. Read-only. |
| VisibleItemsList (Property) | Returns or sets a Variant specifying an array of strings that represent included items in a manual filter applied to a PivotField. Read/write. |
| ClearAllFilters (Method) | Calling this method deletes all filters currently applied to the PivotField. This includes deleting all filters from the PivotFilters collection of the PivotField and removing any manual filtering applied to the PivotField as well. If the PivotField is in the Report Filter area, the item selected will be set to the default item. |
| ClearLabelFilters (Method) | This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField. |
| ClearManualFilter (Method) | Provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables. |
| ClearValueFilters (Method) | Calling this method deletes all value filters in the PivotFilters collection of the PivotField. |
| DrillTo (Method) | The DrillTo method supports drilling to a specified PivotField from another PivotField. |
| PivotFilter (new) | A PivotFilter is applied to a PivotField object. |
| PivotFilters (new) | The PivotFilters object is a collection of PivotFilter objects. |
| PivotItem | |
| DrillTo (Method) | The DrillTo method supports drilling to a specified PivotField from a PivotItem. |
| PivotLine (new) | A PivotLine object is a line of rows or columns in an Excel PivotTable. |
| PivotLineCells (new) | Collection of PivotCell objects for a specific PivotLine. |
| PivotLines (new) | The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows or columns of the pivot. Each line is a set of PivotCells. |
| PivotTable | |
| ShowTableStyleRowStripes (Property) | The ShowTableStyleRowStripes property displays banded rows in which even rows are formatted differently from odd rows. This makes PivotTables easier to read. Read/write Boolean. |
| SortUsingCustomLists (Property) | The SortUsingCustomLists property controls whether custom lists are used for sorting items of fields, both initially when the PivotField is initialized and the PivotItems are ordered by their captions; and later when the user applies a sort. Read/write Boolean. |
| ShowDrillIndicators (Property) | The ShowDrillIndicators property is used for toggling the display of drill indicators in the PivotTable. Read/write Boolean. |
| ShowTableStyleColumnHeaders (Property) | The ShowTableStyleColumnHeaders property is set to True if the coulmn headers should be displayed in the PivotTable. Read/write Boolean. |
| ShowTableStyleColumnStripes (Property) | The ShowTableStyleColumnStripes property displays banded columns in which even columns are formatted differently from odd columns. This makes PivotTables easier to read. Read/write Boolean. |
| ShowTableStyleLastColumn (Property) | |
| ShowTableStyleRowHeaders (Property) | The ShowTableStyleRowHeaders property is set to True if the row headers should be displayed in the PivotTable. Read/write Boolean. |
| TableStyle2 (Property) | The TableStyle2 property specifies the PivotTable style currently applied to the PivotTable. Read/write. |
| ActiveFilters (Property) | Indicates the currently active filter in the specified Pivot Table. Read-only. |
| AllowMultipleFilters (Property) | Sets or retrieves a value that indicates whether a PivotField can have multiple filters applied to it at the same time. Read/write Boolean. |
| CompactLayoutColumnHeader (Property) | Specifies the caption that is displayed in the column header of a PivotTable when in compact row layout form. Read/write String. |
| CompactLayoutRowHeader (Property) | Specifies the caption that is displayed in the row header of a PivotTable when in compact row layout form. Read/write String. |
| CompactRowIndent (Property) | Returns or sets the indent increment for PivotItems when compact row layout form is turned on. Read/write. |
| DisplayContextTooltips (Property) | Controls whether or not tooltips are displayed for PivotTable cells. Read/write Boolean. |
| DisplayFieldCaptions (Property) | Controls whether or not filter buttons and PivotField captions for rows and columns are displayed in the grid. Read/write. |
| DisplayMemberPropertyTooltips (Property) | Controls whether or not to display member properties in tooltips. Read/write Boolean. |
| FieldListSortAscending (Property) | Controls the sort order of fields in the PivotTable Field List. When this property is set to True, the fields are sorted in ascending order. When it is set to False, the fields are sorted in data source order. Read/write. |
| InGridDropZones (Property) | This property is used to toggle in-grid drop zones for a PivotTable object. In some cases, it also affects the layout of the PivotTable. Read/write Boolean. |
| LayoutRowDefault (Property) | This property specifies the layout settings for PivotFields when they are added to the PivotTable for the first time. Read/write xlLayoutRowType. |
| Location (Property) | Gets or sets a String that represents the top-left cell in the body of the specified PivotTable. Read/write. |
| PivotColumnAxis (Property) | Returns a PivotAxis object representing the entire column axis. Read-only PivotAxis. |
| PivotRowAxis (Property) | Returns a PivotAxis object representing the entire row axis. Read-only PivotAxis. |
| PrintDrillIndicators (Property) | Specifies whether or not drill indicators are printed with the Pivot Table. Read/write Boolean. |
| RowAxisLayout (Method) | This method is used for simultaneously setting layout options for all existing PivotFields. |
| SubtotalLocation (Method) | This method changes the subtotal location for all existing PivotFields. Changing the subtotal location has an immediate visual effect only for fields in outline form, but it will be set for fields in tabular form as well. |
| ChangeConnection (Method) | Changes the connection of the specified PivotTable. |
| ChangePivotCache (Method) | Changes the PivotCache of the specified PivotTable. |
| ClearAllFilters (Method) | The ClearAllFilters method deletes all filters currently applied to the PivotTable. This includes deleting all filters in the PivotFilters collection of the PivotTable object, removing any manual filtering applied and setting all PivotFields in the Report Filter area to the default item. |
| ClearTable (Method) | The ClearTable method is used for clearing a PivotTable. Clearing PivotTables includes removing all the fields and deleting all filtering and sorting applied to the PivotTables. This method resets the PivotTable to the state it had right after it was created, before any fields were added to it. |
| ConvertToFormulas (Method) | The ConvertToFormulas method is new in Microsoft Office Excel 2007 and is used for converting a PivotTable to cube formulas. Read/write Boolean. |
| PlotArea | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Position (Property) | Returns or sets the position of the plot area on the chart. Read/write xlChartElementPosition |
| Point | |
| Has3DEffect (Property) | True if a point has a three-dimensional appearance. Read/write Boolean. |
| PictureUnit2 (Property) | Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored). Read/write Double. |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| QueryTable | |
| Sort (Property) | Returns the sort criteria for the query table range. Read-only. |
| WorkbookConnection (Property) | Returns the WorkbookConnection object that the query table uses. Read-only. |
| Range | |
| MDX (Property) | Returns the MDX name for the specified Range object. Read-only String. |
| ServerActions (Property) | Specifies the actions that can be performed on the SharePoint server for a Range object. |
| CountLarge (Property) | Counts the largest value in a given range of values. Read-only Variant. |
| RemoveDuplicates (Method) | Removes duplicate values from a range of values. |
| CalculateRowMajorOrder (Method) | Calculates a specfied range of cells. |
| ExportAsFixedFormat (Method) | Exports to a file of the specified format. |
| Ranges (new) | |
| (Object) | A collection of Range objects that represent worksheets in a workbook. |
| RectangularGradient (new) | |
| (Object) | The RectangularGradient object transitions through a series of colors in a linear manner along a specific angle. |
| Research (new) | |
| (Object) | This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
| Series | |
| PictureUnit2 (Property) | Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored). Read/write Double. |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| SeriesLines | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| ServerViewableItems (new) | A collection of objects that have been marked as viewable on the server. |
| ShadowFormat | |
| Blur (Property) | Returns or sets the degree of blurriness of the specified shadow. Read/write Single. |
| RotateWithShape (Property) | Returns or sets an msoTriState that represents whether to rotate the shadow when rotating the shape. Read/write. |
| Size (Property) | Returns or sets the size of the specified shadow. Read/write Single. |
| Style (Property) | Returns or sets the style of the specified shadow. Read/write msoShadowStyle. |
| Shape | |
| Chart (Property) | Returns a Chart object that represents the chart contained in the shape. Read-only. |
| Glow (Property) | Returns a GlowFormat object for a specified shape that contains glow formatting properties for the shape. Read-only. |
| HasChart (Property) | Returns whether a shape contains a chart. Read-only msoTriState |
| Reflection (Property) | Returns a ReflectionFormat object for a specified shape that contains reflection formatting properties for the shape. Read-only. |
| ShapeStyle (Property) | Returns or sets an msoShapeStyleIndex that represents the shape style of shape range. Read/write. |
| SoftEdge (Property) | Returns a SoftEdgeFormat object for a specified shape that contains soft edge formatting properties for the shape. Read-only. |
| TextFrame2 (Property) | Returns a TextFrame2 object that contains text formatting for the specified shape. Read-only. |
| BackgroundStyle (Property) | Returns or sets the background style. Read/write msoBackgroundStyleIndex |
| ShapeRange | |
| BackgroundStyle (Property) | Returns or sets the background style. Read/write msoBackgroundStyleIndex |
| Glow (Property) | Returns a GlowFormat object for a specified shape range that contains glow formatting properties for the shape range. Read-only. |
| ShapeStyle (Property) | Returns or sets an msoShapeStyleIndex that represents shape style of shape range. Read/write. |
| HasChart (Property) | Returns whether a shape range contains a chart. Read-only msoTriState |
| Reflection (Property) | Returns a ReflectionFormat object for a specified shape range that contains reflection formatting properties for the shape range. Read-only. |
| TextFrame2 (Property) | Returns a TextFrame2 object that contains text formatting for the specified shape range. Read-only. |
| Chart (Property) | Returns a Chart object that represents the chart contained in the shape range. Read-only. |
| SoftEdge (Property) | Returns a SoftEdgeFormat object for a specified shape range that contains soft edge formatting properties for the shape range. Read-only. |
| Shapes | |
| AddChart (Method) | Creates a chart at the specified location on the active sheet. |
| SheetViews (new) | |
| Sort (new) | |
| SortField (new) | The SortField object contains all the sort information for the Worksheet, Lists, and AutoFilter objects. |
| SortFields (new) | The SortFields collection is a collection of SortField objects. It allows developers to store a sort state on workbooks, lists, and autofilters. |
| Tab | |
| ThemeColor (Property) | Returns or sets the theme color in the applied color scheme that is associated with the specified object. Read/write xlThemeColor |
| TintAndShade (Property) | Returns or sets a Single that lightens or darkens a color. |
| TableStyle (new) | |
| (Object) | Represents a single style that can be applied to a table. |
| TableStyleElement (new) | |
| (Object) | Represents a single table style element. |
| TableStyleElements (new) | |
| (Object) | Represents table style elements. |
| TableStyles (new) | |
| (Object) | Represents styles that can be applied to a table. |
| TextFrame2 (new) | |
| (Object) | Represents the text frame in a Shape, ShapeRange, or ChartFormat object. |
| ThreeDFormat | |
| BevelBottomDepth (Property) | Returns or sets the bottom depth when using the bevel effect on a ThreeDFormat object. Read/write Single. |
| BevelBottomInset (Property) | Returns or sets a value indicating whether the bottom insert bevel should be raised for a ThreeDFormat object. Read/write Single. |
| BevelBottomType (Property) | Returns or sets the bottom bevel type for a ThreeDFormat object. Read/write MsoBevelType. |
| BevelTopDepth (Property) | Returns or sets the top depth when using the bevel effect on a ThreeDFormat object. Read/write Single. |
| BevelTopInset (Property) | Returns or sets a value indicating whether the top insert bevel should be raised for a ThreeDFormat object. Read/write Single. |
| BevelTopType (Property) | Returns or sets the top Bevel type for a ThreeDFormat object. Read/write MsoBevelType. |
| ContourColor (Property) | Returns the contour color for a ThreeDFormat object. Read-only ColorFormat. |
| ContourWidth (Property) | Returns or sets the contour width for a ThreeDFormat object. Read/write Single. |
| ProjectText (Property) | Returns or sets the project text state for the specified ThreeDFormat object. Read/write MsoTriState. |
| FieldOfView (Property) | Returns or sets the angle at which a ThreeDFormat object can be viewed. Read/write Single. |
| LightAngle (Property) | Returns or sets the angel of the extrusion lights set on a ThreeDFormat object. Read/write Single. |
| PresetCamera (Property) | Returns or sets the extrusion preset camera for a ThreeDFormat object. Read-only MsoPresetCamera. |
| PresetLighting (Property) | Returns or sets the extrusion preset lighting for a ThreeDFormat object. Read-only MsoLightRigType. |
| RotationZ (Property) | Returns or sets the rotation of the extruded shape around the z-axis in degrees. Read/write Single. |
| Z (Property) | Returns the Z order of the specified ThreeDFormat object. Read/write Single. |
| IncrementRotationHorizontal (Method) | Changes the rotation of the specified shape horizontally by the specified number of degrees. |
| IncrementRotationVertical (Method) | Changes the rotation of the specified shape vertically by the specified number of degrees. |
| IncrementRotationZ (Method) | Changes the rotation of the specified shape around the z-axis by the specified number of degrees. |
| SetPresetCamera (Method) | Sets the camera for the specified ThreeDFormat object. |
| TickLabels | |
| MultiLevel (Property) | Sets whether an axis is multilevel or not. Read/write Boolean. |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Top10 (new) | |
| (Object) | |
| Trendline | |
| Backward2 (Property) | Returns or sets the number of periods (or units on a scatter chart) that the trendline extends backward. Read/write Double. |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Forward2 (Property) | Returns or sets the number of periods (or units on a scatter chart) that the trendline extends forward. Read/write Double. |
| UniqueValues (new) | |
| (Object) | The UniqueValues object uses the DupeUnique property to returns or sets an enum that determines whether the rule should look for duplicate or unique values in the range. |
| UpBars | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Walls | |
| Format (Property) | Returns the ChartFormat object. Read-only. |
| Thickness (Property) | Returns or sets a Long specifying the thickness of the wall. Read/write. |
| Window | |
| ActiveSheetView (Property) | Returns an object that represents the view of the active sheet in the specified window. Read-only. |
| AutoFilterDateGrouping (Property) | True if the auto filter for date grouping is currently displayed in the specified window. Read/write Boolean. |
| DisplayRuler (Property) | True if a ruler is displayed for the specified window. Read/write Boolean. |
| DisplayWhitespace (Property) | True if whitespace is displayed. Read/write Boolean. |
| SheetViews (Property) | Returns the SheetViews object for the specified window. Read-only. |
| Workbook | |
| ShowPivotChartActiveFields (Property) | This property controls the visibility of the PivotChart Filter Pane. Read/write Boolean. |
| Signatures (Property) | Returns the digital signatures for a workbook. Read-only. |
| TableStyles (Property) | Returns a TableStyles collection object for the current workbook that refers to the styles used in the current workbook. Read-only. |
| Theme (Property) | Returns the theme applied to the current workbook. Read-only. |
| Research (Property) | Returns a Research object that represents the research service for a workbook. Read-only. |
| ServerPolicy (Property) | Returns a ServerPolicy object that represents a policy specified for a workbook stored on a server running Office SharePoint Server 2007. Read-only. |
| ServerViewableItems (Property) | Allows a developer to interact with the list of published objects in the workbook that are shown on the server. Read-only. |
| HasVBProject (Property) | Returns a Boolean that represents whether a workbook has an attached Microsoft Visual Basic for Applications project. Read-only Boolean. |
| IconSets (Property) | This property is used to filter data in a workbook based on a cell icon from the IconSet collection. Read-only. |
| EncryptionProvider (Property) | Returns a String specifying the name of the algorithm encryption provider that Microsoft Office Excel 2007 uses when encrypting documents. Read/write. |
| CheckCompatibility (Property) | Controls whether or not the compatibility checker is run automatically when the workbook is saved. Read/write Boolean. |
| Connections (Property) | The Connections property establishes a connection between the workbook and an ODBC or an OLEDB data source and refreshes the data without prompting the user. Read-only. |
| ConnectionsDisabled (Property) | |
| ContentTypeProperties (Property) | Returns a MetaProperties collection that describes the metadata stored in the workbook. Read-only. |
| CustomXMLParts (Property) | Returns a CustomXMLParts collection that represents the custom XML in the XML data store. Read-only. |
| DefaultPivotTableStyle (Property) | Specifies the table style from the TableStyles collection that is used as the default style for PivotTables. Read/write. |
| DefaultTableStyle (Property) | Specifies the table style from the TableStyles collection that is used as the default TableStyle. Read/write Variant. |
| DocumentInspectors (Property) | Returns a DocumentInspectors collection that represents the Document Inspector modules for the specified workbook. Read-only. |
| DoNotPromptForConvert (Property) | Returns or sets if the user should be prompted to convert the workbook if the workbook contains features that are not supported by versions of Excel earlier than Excel 2007. Read/write Boolean. |
| Excel8CompatibilityMode (Property) | The Excel8CompatibilityMode property provides developers with a way to check if the workbook is in compatibility mode. Read-only Boolean. |
| Final (Property) | Returns or sets a Boolean that indicates whether a workbook is final. Read/write Boolean. |
| ForceFullCalculation (Property) | Forces something. Read/write. |
| RemoveDocumentInformation (Method) | Removes all information of the specified type from the workbook. |
| LockServerFile (Method) | Locks the workbook on the server to prevent modification. |
| ApplyTheme (Method) | Applies the specified theme to the current workbook. |
| EnableConnections (Method) | The EnableConnections method allows developers to programmatically enable data connections within the workbook for the user. |
| ExportAsFixedFormat (Method) | The ExportAsFixedFormat method is used to publish a workbook to either the PDF or XPS format. |
| GetWorkflowTasks (Method) | Returns the collection of WorkflowTask objects for the specified workbook. |
| GetWorkflowTemplates (Method) | Returns the collection of WorkflowTemplate objects for the specified workbook. |
| WorkbookConnection (new) | |
| (Object) | A connection is a set of information needed to obtain data from an external data source other than an Microsoft Office Excel 2007 workbook. |
| Worksheet | |
| Sort (Property) | Returns the sorted values in the current worksheet. Read-only. |
| EnableFormatConditionsCalculation (Property) | Returns or sets if conditional formats will will occur automatically as needed. Read/write Boolean. |
| ExportAsFixedFormat (Method) | Exports to a file of the specified format. |
| WorksheetFunction | |
| ALL Analysis-ToolPak Functions (Method) | |
| WorksheetView (new) | |
| (Object) | This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
| XmlMap | |
| WorkbookConnection (Property) | Returns a new connection for the specified XMLMap object. Read-only. |
Events
To see a list of all the events, please refer to the Events page.
| AfterCalculate | Application | The AfterCalculate event occurs when all pending refresh activity (both synchronous and asynchronous) and all of the resultant calculation activities have been completed. |
| RowsetComplete | Workbook | The WorkbookRowsetComplete event occurs when the user either drills through the recordset or invokes the rowset action on an OLAP Pivot Table. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext