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
Advertisements

About Colin Legg

RAD Developer Microsoft MVP - Excel 2009 - 2014
This entry was posted in Microsoft Excel, Microsoft Office and tagged , , , , . Bookmark the permalink.

3 Responses to Excel 2013 Preview: New Excel Object Model Members

  1. dougaj4 says:

    Thanks for the list. I agree that the new worksheet functions are disapointing. I really don’t see the point of providing new esoteric trig functions (all of which can be simply derived by anyone with the knowledge to use them properly), but not provide a VBA ATan2 function. Also some basic interpolation functions and functions to convert between rectangular and polar coordinate systems would be good, from my point of view.

    Like

  2. Pingback: Excel 2013 Preview: New Worksheet Functions | RAD Excel

  3. Colin Legg says:

    A small development since this was posted. WordPress hosted blogs now offer support for MS Skydrive Excel Web Apps! Here’s the support article:
    http://en.support.wordpress.com/excel-web-app/

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s