Excel 2013 Preview: New Excel Object Model Members

I’ve cobbled together the below table of Excel Object Model members which have been introduced  between Excel 2010 (Office Professional Plus) and the Excel 2013 Preview (Office 365 Home Premium). Don’t worry, I didn’t spend hours manually trawling through the object browser to spot the differences: I used the TypeLib Information library (tlbinf32.dll) to do the hard work. Since the list is quite long I’ve manually removed some of the members which were effectively duplicates – let me know if I’ve left out something.

Looking down the list, there are some new classes to get stuck into and a handful of new event handlers. I confess that I’m a little disappointed that none of the worksheet functions in my wish list are among the 47 new members of the WorksheetFunction class, especially when a few of the new ones seem to be pretty useless. DAYS() anyone? There are some new worksheet functions which aren’t in the WorksheetFunction class, so I’ll compile a separate list for them.

It would have been pretty cool to put an Excel Interactive Button on this post so you could navigate the table more easily, but unfortunately they can’t be used on a wordpress.com hosted blog. So how are you all getting on with the preview and do you like the new features?

Class.Member

Application.ChartDataPointTrack

Application.EnableMacroAnimations

Application.FlashFill

Application.FlashFillMode

Application.MergeInstances

Application.QuickAnalysis

Application.SheetBeforeDelete

Application.SheetLensGalleryRenderComplete

Application.SheetTableUpdate

Application.ShowQuickAnalysis

Application.WorkbookModelChange

CalculatedMember.MeasureGroup

CalculatedMember.NumberFormat

CalculatedMember.ParentHierarchy

CalculatedMember.ParentMember

CalculatedMembers.AddCalculatedMember

CategoryCollection._Default

CategoryCollection.Application

CategoryCollection.Count

CategoryCollection.Creator

CategoryCollection.Item

CategoryCollection.Parent

Chart.CategoryLabelLevel

Chart.ChartColor

Chart.ClearToMatchColorStyle

Chart.DeleteHiddenContent

Chart.FullSeriesCollection

Chart.HasHiddenContent

Chart.SeriesNameLevel

ChartCategory.Application

ChartCategory.Creator

ChartCategory.IsFiltered

ChartCategory.Name

ChartCategory.Parent

ChartFormat.Adjustments

ChartFormat.AutoShapeType

ChartGroup.CategoryCollection

ChartGroup.FullCategoryCollection

Charts.Add2

Connections._Add

Connections._AddFromFile

CubeFields.GetMeasure

DataFeedConnection.AlwaysUseConnectionFile

DataFeedConnection.Application

DataFeedConnection.CancelRefresh

DataFeedConnection.CommandText

DataFeedConnection.CommandType

DataFeedConnection.Connection

DataFeedConnection.Creator

DataFeedConnection.EnableRefresh

DataFeedConnection.Parent

DataFeedConnection.Refresh

DataFeedConnection.RefreshDate

DataFeedConnection.Refreshing

DataFeedConnection.RefreshOnFileOpen

DataFeedConnection.RefreshPeriod

DataFeedConnection.SaveAsODC

DataFeedConnection.SavePassword

DataFeedConnection.ServerCredentialsMethod

DataFeedConnection.SourceConnectionFile

DataFeedConnection.SourceDataFile

DataLabel._Height

DataLabel._Width

DataLabel.ShowRange

DataLabels.Propagate

DataLabels.ShowRange

DialogSheets.Add2

FullSeriesCollection._Default

FullSeriesCollection._NewEnum

FullSeriesCollection.Application

FullSeriesCollection.Count

FullSeriesCollection.Creator

FullSeriesCollection.Item

FullSeriesCollection.Parent

ListObject.ShowAutoFilterDropDown

ListObject.Slicers

ListObject.TableObject

Model.AddConnection

Model.Application

Model.CreateModelWorkbookConnection

Model.Creator

Model.DataModelConnection

Model.Initialize

Model.ModelRelationships

Model.ModelTables

Model.Name

Model.Parent

Model.Refresh

ModelChanges.Application

ModelChanges.ColumnsAdded

ModelChanges.ColumnsChanged

ModelChanges.ColumnsDeleted

ModelChanges.Creator

ModelChanges.MeasuresAdded

ModelChanges.Parent

ModelChanges.RelationshipChange

ModelChanges.Source

ModelChanges.TableNamesChanged

ModelChanges.TablesAdded

ModelChanges.TablesDeleted

ModelChanges.TablesModified

ModelChanges.UnknownChange

ModelColumnChange.Application

ModelColumnChange.ColumnName

ModelColumnChange.Creator

ModelColumnChange.Parent

ModelColumnChange.TableName

ModelColumnChanges._Default

ModelColumnChanges._NewEnum

ModelColumnChanges.Application

ModelColumnChanges.Count

ModelColumnChanges.Creator

ModelColumnChanges.Item

ModelColumnChanges.Parent

ModelColumnName.Application

ModelColumnName.ColumnName

ModelColumnName.Creator

ModelColumnName.Parent

ModelColumnName.TableName

ModelColumnNames._Default

ModelColumnNames._NewEnum

ModelColumnNames.Application

ModelColumnNames.Count

ModelColumnNames.Creator

ModelColumnNames.Item

ModelColumnNames.Parent

ModelConnection.ADOConnection

ModelConnection.Application

ModelConnection.CommandText

ModelConnection.CommandType

ModelConnection.Creator

ModelConnection.Parent

ModelMeasureName.Application

ModelMeasureName.Creator

ModelMeasureName.MeasureName

ModelMeasureName.Parent

ModelMeasureName.TableName

ModelMeasureNames._Default

ModelMeasureNames._NewEnum

ModelMeasureNames.Application

ModelMeasureNames.Count

ModelMeasureNames.Creator

ModelMeasureNames.Item

ModelMeasureNames.Parent

ModelRelationship.Active

ModelRelationship.Application

ModelRelationship.Creator

ModelRelationship.Delete

ModelRelationship.ForeignKeyColumn

ModelRelationship.ForeignKeyTable

ModelRelationship.Parent

ModelRelationship.PrimaryKeyColumn

ModelRelationship.PrimaryKeyTable

ModelRelationships._Default

ModelRelationships._NewEnum

ModelRelationships.Add

ModelRelationships.Application

ModelRelationships.Count

ModelRelationships.Creator

ModelRelationships.Item

ModelRelationships.Parent

ModelTable.Application

ModelTable.Creator

ModelTable.LastRefresh

ModelTable.ModelTableColumns

ModelTable.Name

ModelTable.Parent

ModelTable.RecordCount

ModelTable.Refresh

ModelTable.SourceName

ModelTable.SourceWorkbookConnection

ModelTableColumn.Application

ModelTableColumn.Creator

ModelTableColumn.DataType

ModelTableColumn.Name

ModelTableColumn.Parent

ModelTableColumns._Default

ModelTableColumns._NewEnum

ModelTableColumns.Application

ModelTableColumns.Count

ModelTableColumns.Creator

ModelTableColumns.Item

ModelTableColumns.Parent

ModelTableNameChange.Application

ModelTableNameChange.Creator

ModelTableNameChange.Parent

ModelTableNameChange.TableNameNew

ModelTableNameChange.TableNameOld

ModelTableNameChanges._Default

ModelTableNameChanges._NewEnum

ModelTableNameChanges.Application

ModelTableNameChanges.Count

ModelTableNameChanges.Creator

ModelTableNameChanges.Item

ModelTableNameChanges.Parent

ModelTableNames._Default

ModelTableNames.Application

ModelTableNames.Count

ModelTableNames.Creator

ModelTableNames.Item

ModelTableNames.Parent

ModelTables._Default

ModelTables._NewEnum

ModelTables.Application

ModelTables.Count

ModelTables.Creator

ModelTables.Item

ModelTables.Parent

Modules.Add2

PivotCache.CreatePivotChart

PivotCell.ServerActions

PivotFilter.MovingPeriod

PivotFilter.WholeDayFilter

PivotFilters._Add

PivotLine.PivotLineCellsFull

PivotLineCells.Full

PivotTable.DrillDown

PivotTable.DrillTo

PivotTable.DrillUp

PivotTable.Dummy2

PivotTable.Hidden

PivotTable.PivotChart

PivotTable.PivotValueCell

PivotValueCell.Application

PivotValueCell.Creator

PivotValueCell.Parent

PivotValueCell.PivotCell

PivotValueCell.ServerActions

PivotValueCell.ShowDetail

PivotValueCell.Value

QuickAnalysis.Application

QuickAnalysis.Creator

QuickAnalysis.Hide

QuickAnalysis.Parent

QuickAnalysis.Show

Range.FlashFill

Series.IsFiltered

Shapes.AddChart2

Sheets.Add2

Slicer.SlicerCacheType

Slicer.TimelineViewState

SlicerCache.ClearAllFilters

SlicerCache.ClearDateFilter

SlicerCache.FilterCleared

SlicerCache.List

SlicerCache.ListObject

SlicerCache.RequireManualUpdate

SlicerCache.SlicerCacheType

SlicerCache.TimelineState

SlicerCaches._Add

TableObject.AdjustColumnWidth

TableObject.Application

TableObject.Creator

TableObject.Delete

TableObject.Destination

TableObject.EnableEditing

TableObject.EnableRefresh

TableObject.FetchedRowOverflow

TableObject.ListObject

TableObject.Parent

TableObject.PreserveColumnInfo

TableObject.PreserveFormatting

TableObject.Refresh

TableObject.RefreshStyle

TableObject.ResultRange

TableObject.RowNumbers

TableObject.WorkbookConnection

TableStyle.ShowAsAvailableTimelineStyle

TextConnection.Application

TextConnection.Connection

TextConnection.Creator

TextConnection.Parent

TextConnection.TextFileColumnDataTypes

TextConnection.TextFileCommaDelimiter

TextConnection.TextFileConsecutiveDelimiter

TextConnection.TextFileDecimalSeparator

TextConnection.TextFileFixedColumnWidths

TextConnection.TextFileHeaderRow

TextConnection.TextFileOtherDelimiter

TextConnection.TextFileParseType

TextConnection.TextFilePlatform

TextConnection.TextFilePromptOnRefresh

TextConnection.TextFileSemicolonDelimiter

TextConnection.TextFileSpaceDelimiter

TextConnection.TextFileStartRow

TextConnection.TextFileTabDelimiter

TextConnection.TextFileTextQualifier

TextConnection.TextFileThousandsSeparator

TextConnection.TextFileTrailingMinusNumbers

TextConnection.TextFileVisualLayout

TimelineState.Application

TimelineState.Creator

TimelineState.EndDate

TimelineState.FilterType

TimelineState.FilterValue1

TimelineState.FilterValue2

TimelineState.MovingPeriod

TimelineState.Parent

TimelineState.SetFilterDateRange

TimelineState.SingleRangeFilterState

TimelineState.StartDate

TimelineViewState.Application

TimelineViewState.Creator

TimelineViewState.Level

TimelineViewState.Parent

TimelineViewState.ShowHeader

TimelineViewState.ShowHorizontalScrollbar

TimelineViewState.ShowSelectionLabel

TimelineViewState.ShowTimeLevel

Window.Hwnd

Workbook.CaseSensitive

Workbook.ChartDataPointTrack

Workbook.DefaultTimelineStyle

Workbook.Model

Workbook.ModelChange

Workbook.PivotTables

Workbook.SheetBeforeDelete

Workbook.SheetLensGalleryRenderComplete

Workbook.SheetTableUpdate

Workbook.UseWholeCellCriteria

Workbook.UseWildcards

WorkbookConnection.DataFeedConnection

WorkbookConnection.InModel

WorkbookConnection.ModelConnection

WorkbookConnection.ModelTables

WorkbookConnection.RefreshWithRefreshAll

WorkbookConnection.TextConnection

WorkbookConnection.WorksheetDataConnection

Worksheet.BeforeDelete

Worksheet.SheetLensGalleryRenderComplete

Worksheet.TableUpdate

WorksheetDataConnection.Application

WorksheetDataConnection.CommandText

WorksheetDataConnection.CommandType

WorksheetDataConnection.Connection

WorksheetDataConnection.Creator

WorksheetDataConnection.Parent

WorksheetFunction.Acot

WorksheetFunction.Acoth

WorksheetFunction.Arabic

WorksheetFunction.Base

WorksheetFunction.Binom_Dist_Range

WorksheetFunction.Bitand

WorksheetFunction.Bitlshift

WorksheetFunction.Bitor

WorksheetFunction.Bitrshift

WorksheetFunction.Bitxor

WorksheetFunction.Ceiling_Math

WorksheetFunction.Combina

WorksheetFunction.Cot

WorksheetFunction.Coth

WorksheetFunction.Csc

WorksheetFunction.Csch

WorksheetFunction.Days

WorksheetFunction.Decimal

WorksheetFunction.EncodeURL

WorksheetFunction.FilterXML

WorksheetFunction.Floor_Math

WorksheetFunction.Gamma

WorksheetFunction.Gauss

WorksheetFunction.IfNa

WorksheetFunction.ImCosh

WorksheetFunction.ImCot

WorksheetFunction.ImCsc

WorksheetFunction.ImCsch

WorksheetFunction.ImSec

WorksheetFunction.ImSech

WorksheetFunction.ImSinh

WorksheetFunction.ImTan

WorksheetFunction.IsFormula

WorksheetFunction.IsoWeekNum

WorksheetFunction.Munit

WorksheetFunction.NumberValue

WorksheetFunction.PDuration

WorksheetFunction.Permutationa

WorksheetFunction.Phi

WorksheetFunction.Rri

WorksheetFunction.Sec

WorksheetFunction.Sech

WorksheetFunction.Skew_p

WorksheetFunction.Unichar

WorksheetFunction.Unicode

WorksheetFunction.WebService

WorksheetFunction.Xor

Worksheets.Add2

XlAutoFillType.xlFlashFill

XlBuiltInDialog.xlDialogCreateRelationship

XlBuiltInDialog.xlDialogManageRelationships

XlBuiltInDialog.xlDialogRecommendedPivotTables

XlCalcMemNumberFormatType.xlNumberFormatTypeDefault

XlCalcMemNumberFormatType.xlNumberFormatTypeNumber

XlCalcMemNumberFormatType.xlNumberFormatTypePercent

XlCalculatedMemberType.xlCalculatedMeasure

XlCategoryLabelLevel.xlCategoryLabelLevelAll

XlCategoryLabelLevel.xlCategoryLabelLevelCustom

XlCategoryLabelLevel.xlCategoryLabelLevelNone

XlCmdType.xlCmdDAX

XlCmdType.xlCmdExcel

XlCmdType.xlCmdTableCollection

XlConnectionType.xlConnectionTypeDATAFEED

XlConnectionType.xlConnectionTypeMODEL

XlConnectionType.xlConnectionTypeNOSOURCE

XlConnectionType.xlConnectionTypeWORKSHEET

XlConsolidationFunction.xlDistinctCount

XlCubeFieldSubType.xlCubeImplicitMeasure

XlFileFormat.xlOpenXMLStrictWorkbook

XlFilterStatus.xlFilterStatusDateHasTime

XlFilterStatus.xlFilterStatusDateWrongOrder

XlFilterStatus.xlFilterStatusInvalidDate

XlFilterStatus.xlFilterStatusOK

XlListObjectSourceType.xlSrcModel

XlModelChangeSource.xlChangeByExcel

XlModelChangeSource.xlChangeByPowerPivotAddIn

XlPivotTableVersionList.xlPivotTableVersion15

XlQuickAnalysisMode.xlFormatConditions

XlQuickAnalysisMode.xlLensOnly

XlQuickAnalysisMode.xlRecommendedCharts

XlQuickAnalysisMode.xlSparklines

XlQuickAnalysisMode.xlTables

XlQuickAnalysisMode.xlTotals

XlRemoveDocInfoType.xlRDIExcelDataModel

XlRemoveDocInfoType.xlRDIInlineWebExtensions

XlRemoveDocInfoType.xlRDITaskpaneWebExtensions

XlSeriesNameLevel.xlSeriesNameLevelAll

XlSeriesNameLevel.xlSeriesNameLevelCustom

XlSeriesNameLevel.xlSeriesNameLevelNone

XlSlicerCacheType.xlSlicer

XlSlicerCacheType.xlTimeline

XlSlicerCrossFilterType.xlSlicerCrossFilterHideButtonsWithNoData

XlTableStyleElementType.xlTimelinePeriodLabels1

XlTableStyleElementType.xlTimelinePeriodLabels2

XlTableStyleElementType.xlTimelineSelectedTimeBlock

XlTableStyleElementType.xlTimelineSelectedTimeBlockSpace

XlTableStyleElementType.xlTimelineSelectionLabel

XlTableStyleElementType.xlTimelineTimeLevel

XlTableStyleElementType.xlTimelineUnselectedTimeBlock

XlTimelineLevel.xlTimelineLevelDays

XlTimelineLevel.xlTimelineLevelMonths

XlTimelineLevel.xlTimelineLevelQuarters

XlTimelineLevel.xlTimelineLevelYears

XlTimeMoving.xlTimeMovingDaily

XlTimeMoving.xlTimeMovingMonthly

XlTimeMoving.xlTimeMovingQuarterly

XlTimeMoving.xlTimeMovingWeekly

XlTimeMoving.xlTimeMovingYearly

XlTimeMoving.xlTimeMovingYTD

XlTimeMoving.xlTimeNotMoving