Object Model Map [Excel 2007 Developer Reference]

Object Model Map

Object Model Map

Bb332345.xlimgAllObjectsBanner_ZA10219070(en-us,office.12).png

Bb332345.xlimgAboveAverage_ZA10219064(en-us,office.12).png

Bb332345.xlimgBorders_ZA10219082(en-us,office.12).png

Bb332345.xlimgBorder_ZA10219081(en-us,office.12).png

Bb332345.xlimgFont_ZA10219138(en-us,office.12).png

Bb332345.xlimgInterior_ZA10219158(en-us,office.12).png

Bb332345.xlimgRange_ZA10219228(en-us,office.12).png

Bb332345.xlimgActions_ZA10219066(en-us,office.12).png

Bb332345.xlimgAreas_ZA10219074(en-us,office.12).png

Bb332345.xlimgCharacters_ZA10219090(en-us,office.12).png

Bb332345.xlimgComment_ZA10219107(en-us,office.12).png

Bb332345.xlimgErrors_ZA10219133(en-us,office.12).png

Bb332345.xlimgFormatConditions_ZA10219141(en-us,office.12).png

Bb332345.xlimgHyperlinks_ZA10219151(en-us,office.12).png

Bb332345.xlimgListObject_ZA10219172(en-us,office.12).png

Bb332345.xlimgPhonetic_ZA10219198(en-us,office.12).png

Bb332345.xlimgPhonetics_ZA10219199(en-us,office.12).png

Bb332345.xlimgPivotCell_ZA10219204(en-us,office.12).png

Bb332345.xlimgPivotField_ZA10219205(en-us,office.12).png

Bb332345.xlimgPivotItem_ZA10219211(en-us,office.12).png

Bb332345.xlimgPivotTable_ZA10219218(en-us,office.12).png

Bb332345.xlimgQueryTable_ZA10219226(en-us,office.12).png

Bb332345.xlimgSmartTags_ZA10219256(en-us,office.12).png

Bb332345.xlimgSoundNote_ZA10219260(en-us,office.12).png

Bb332345.xlimgValidation_ZA10219284(en-us,office.12).png

Bb332345.xlimgWorksheet_ZA10219296(en-us,office.12).png

Bb332345.xlimgXPath_ZA10219308(en-us,office.12).png

Bb332345.xlimgAction_ZA10219065(en-us,office.12).png

Bb332345.xlimgAddIn_ZA10219067(en-us,office.12).png

Bb332345.xlimgAddIns_ZA10219068(en-us,office.12).png

Bb332345.xlimgAdjustments_ZA10219069(en-us,office.12).png

Bb332345.xlimgAllowEditRange_ZA10219071(en-us,office.12).png

Bb332345.xlimgAllowEditRanges_ZA10219072(en-us,office.12).png

Bb332345.xlimgApplication_ZA10219073(en-us,office.12).png

Bb332345.xlimgAutoCorrect_ZA10219075(en-us,office.12).png

Bb332345.xlimgAutoRecover_ZA10219077(en-us,office.12).png

Bb332345.xlimgCellFormat_ZA10219089(en-us,office.12).png

Bb332345.xlimgChart_ZA10219091(en-us,office.12).png

Bb332345.xlimgDefaultWebOptions_ZA10219123(en-us,office.12).png

Bb332345.xlimgDialogs_ZA10219125(en-us,office.12).png

Bb332345.xlimgDialog_ZA10219124(en-us,office.12).png

Bb332345.xlimgErrorCheckingOptions_ZA10219132(en-us,office.12).png

Bb332345.xlimgMultiThreadedCalculation_ZA10219178(en-us,office.12).png

Bb332345.xlimgNames_ZA10219180(en-us,office.12).png

Bb332345.xlimgODBCErrors_ZA10219183(en-us,office.12).png

Bb332345.xlimgODBCError_ZA10219182(en-us,office.12).png

Bb332345.xlimgOLEDBErrors_ZA10219186(en-us,office.12).png

Bb332345.xlimgOLEDBError_ZA10219185(en-us,office.12).png

Bb332345.xlimgRecentFiles_ZA10219231(en-us,office.12).png

Bb332345.xlimgRecentFile_ZA10219230(en-us,office.12).png

Bb332345.xlimgRTD_ZA10219235(en-us,office.12).png

Bb332345.xlimgSheets_ZA10219248(en-us,office.12).png

Bb332345.xlimgSmartTagRecognizers_ZA10219255(en-us,office.12).png

Bb332345.xlimgSmartTagRecognizer_ZA10219254(en-us,office.12).png

Bb332345.xlimgSpeech_ZA10219261(en-us,office.12).png

Bb332345.xlimgSpellingOptions_ZA10219262(en-us,office.12).png

Bb332345.xlimgUsedObjects_ZA10219281(en-us,office.12).png

Bb332345.xlimgWatches_ZA10219289(en-us,office.12).png

Bb332345.xlimgWatch_ZA10219288(en-us,office.12).png

Bb332345.xlimgWindow_ZA10219291(en-us,office.12).png

Bb332345.xlimgWindows_ZA10219292(en-us,office.12).png

Bb332345.xlimgWorkbook_ZA10219293(en-us,office.12).png

Bb332345.xlimgWorkbooks_ZA10219295(en-us,office.12).png

Bb332345.xlimgWorksheetFunction_ZA10219297(en-us,office.12).png

Bb332345.xlimgAutoFilter_ZA10219076(en-us,office.12).png

Bb332345.xlimgAxes_ZA10219078(en-us,office.12).png

Bb332345.xlimgAxis_ZA10219079(en-us,office.12).png

Bb332345.xlimgAxisTitle_ZA10219080(en-us,office.12).png

Bb332345.xlimgChartFormat_ZA10219093(en-us,office.12).png

Bb332345.xlimgDisplayUnitLabel_ZA10219127(en-us,office.12).png

Bb332345.xlimgGridlines_ZA10219144(en-us,office.12).png

Bb332345.xlimgTickLabels_ZA10219274(en-us,office.12).png

Bb332345.xlimgCalculatedFields_ZA10219083(en-us,office.12).png

Bb332345.xlimgCalculatedItems_ZA10219085(en-us,office.12).png

Bb332345.xlimgCalculatedMember_ZA10219086(en-us,office.12).png

Bb332345.xlimgCalculatedMembers_ZA10219087(en-us,office.12).png

Bb332345.xlimgCalloutFormat_ZA10219088(en-us,office.12).png

Bb332345.xlimgChartArea_ZA10219092(en-us,office.12).png

Bb332345.xlimgChartGroup_ZA10219094(en-us,office.12).png

Bb332345.xlimgDownBars_ZA10219128(en-us,office.12).png

Bb332345.xlimgDropLines_ZA10219129(en-us,office.12).png

Bb332345.xlimgHiLoLines_ZA10219147(en-us,office.12).png

Bb332345.xlimgSeriesLines_ZA10219240(en-us,office.12).png

Bb332345.xlimgUpBars_ZA10219280(en-us,office.12).png

Bb332345.xlimgChartGroups_ZA10219095(en-us,office.12).png

Bb332345.xlimgChartObject_ZA10219096(en-us,office.12).png

Bb332345.xlimgShapeRange_ZA10219246(en-us,office.12).png

Bb332345.xlimgChartObjects_ZA10219097(en-us,office.12).png

Bb332345.xlimgCharts_ZA10219098(en-us,office.12).png

Bb332345.xlimgHPageBreaks_ZA10219149(en-us,office.12).png

Bb332345.xlimgVPageBreaks_ZA10219286(en-us,office.12).png

Bb332345.xlimgChartTitle_ZA10219099(en-us,office.12).png

Bb332345.xlimgChartView_ZA10219100(en-us,office.12).png

Bb332345.xlimgColorFormat_ZA10219101(en-us,office.12).png

Bb332345.xlimgColorScale_ZA10219102(en-us,office.12).png

Bb332345.xlimgColorScaleCriteria_ZA10219103(en-us,office.12).png

Bb332345.xlimgColorScaleCriterion_ZA10219104(en-us,office.12).png

Bb332345.xlimgColorStop_ZA10219105(en-us,office.12).png

Bb332345.xlimgColorStops_ZA10219106(en-us,office.12).png

Bb332345.xlimgComments_ZA10219108(en-us,office.12).png

Bb332345.xlimgConditionValue_ZA10219109(en-us,office.12).png

Bb332345.xlimgConnections_ZA10219110(en-us,office.12).png

Bb332345.xlimgConnectorFormat_ZA10219111(en-us,office.12).png

Bb332345.xlimgControlFormat_ZA10219112(en-us,office.12).png

Bb332345.xlimgCubeField_ZA10219113(en-us,office.12).png

Bb332345.xlimgCubeFields_ZA10219114(en-us,office.12).png

Bb332345.xlimgCustomProperties_ZA10219115(en-us,office.12).png

Bb332345.xlimgCustomProperty_ZA10219116(en-us,office.12).png

Bb332345.xlimgCustomView_ZA10219117(en-us,office.12).png

Bb332345.xlimgCustomViews_ZA10219118(en-us,office.12).png

Bb332345.xlimgDatabar_ZA10219119(en-us,office.12).png

Bb332345.xlimgDataLabel_ZA10219120(en-us,office.12).png

Bb332345.xlimgDataLabels_ZA10219121(en-us,office.12).png

Bb332345.xlimgDataTable_ZA10219122(en-us,office.12).png

Bb332345.xlimgDialogSheetView_ZA10219126(en-us,office.12).png

Bb332345.xlimgError_ZA10219130(en-us,office.12).png

Bb332345.xlimgErrorBars_ZA10219131(en-us,office.12).png

Bb332345.xlimgFillFormat_ZA10219134(en-us,office.12).png

Bb332345.xlimgFilter_ZA10219135(en-us,office.12).png

Bb332345.xlimgFilters_ZA10219136(en-us,office.12).png

Bb332345.xlimgFloor_ZA10219137(en-us,office.12).png

Bb332345.xlimgFormatColor_ZA10219139(en-us,office.12).png

Bb332345.xlimgFormatCondition_ZA10219140(en-us,office.12).png

Bb332345.xlimgFreeformBuilder_ZA10219142(en-us,office.12).png

Bb332345.xlimgGraphic_ZA10219143(en-us,office.12).png

Bb332345.xlimgGroupShapes_ZA10219145(en-us,office.12).png

Bb332345.xlimgHeaderFooter_ZA10219146(en-us,office.12).png

Bb332345.xlimgHPageBreak_ZA10219148(en-us,office.12).png

Bb332345.xlimgHyperlink_ZA10219150(en-us,office.12).png

Bb332345.xlimgIcon_ZA10219152(en-us,office.12).png

Bb332345.xlimgIconCriteria_ZA10219153(en-us,office.12).png

Bb332345.xlimgIconCriterion_ZA10219154(en-us,office.12).png

Bb332345.xlimgIconSet_ZA10219155(en-us,office.12).png

Bb332345.xlimgIconSetCondition_ZA10219156(en-us,office.12).png

Bb332345.xlimgIconSets_ZA10219157(en-us,office.12).png

Bb332345.xlimgIRtdServer_ZA10219159(en-us,office.12).png

Bb332345.xlimgIRTDUpdateEvent_ZA10219160(en-us,office.12).png

Bb332345.xlimgLeaderLines_ZA10219161(en-us,office.12).png

Bb332345.xlimgLegend_ZA10219162(en-us,office.12).png

Bb332345.xlimgLegendEntries_ZA10219163(en-us,office.12).png

Bb332345.xlimgLegendEntry_ZA10219164(en-us,office.12).png

Bb332345.xlimgLegendKey_ZA10219165(en-us,office.12).png

Bb332345.xlimgLinearGradient_ZA10219166(en-us,office.12).png

Bb332345.xlimgLineFormat_ZA10219167(en-us,office.12).png

Bb332345.xlimgLinkFormat_ZA10219168(en-us,office.12).png

Bb332345.xlimgListColumn_ZA10219169(en-us,office.12).png

Bb332345.xlimgListColumns_ZA10219170(en-us,office.12).png

Bb332345.xlimgListDataFormat_ZA10219171(en-us,office.12).png

Bb332345.xlimgListObjects_ZA10219173(en-us,office.12).png

Bb332345.xlimgListRow_ZA10219174(en-us,office.12).png

Bb332345.xlimgListRows_ZA10219175(en-us,office.12).png

Bb332345.xlimgMailer_ZA10219176(en-us,office.12).png

Bb332345.xlimgModuleView_ZA10219177(en-us,office.12).png

Bb332345.xlimgName_ZA10219179(en-us,office.12).png

Bb332345.xlimgODBCConnection_ZA10219181(en-us,office.12).png

Bb332345.xlimgOLEDBConnection_ZA10219184(en-us,office.12).png

Bb332345.xlimgOLEFormat_ZA10219187(en-us,office.12).png

Bb332345.xlimgOLEObject_ZA10219188(en-us,office.12).png

Bb332345.xlimgOLEObjects_ZA10219189(en-us,office.12).png

Bb332345.xlimgOutline_ZA10219190(en-us,office.12).png

Bb332345.xlimgPage_ZA10219191(en-us,office.12).png

Bb332345.xlimgPages_ZA10219192(en-us,office.12).png

Bb332345.xlimgPageSetup_ZA10219193(en-us,office.12).png

Bb332345.xlimgPane_ZA10219194(en-us,office.12).png

Bb332345.xlimgPanes_ZA10219195(en-us,office.12).png

Bb332345.xlimgParameter_ZA10219196(en-us,office.12).png

Bb332345.xlimgParameters_ZA10219197(en-us,office.12).png

Bb332345.xlimgPictureFormat_ZA10219200(en-us,office.12).png

Bb332345.xlimgPivotAxis_ZA10219201(en-us,office.12).png

Bb332345.xlimgPivotCache_ZA10219202(en-us,office.12).png

Bb332345.xlimgPivotCaches_ZA10219203(en-us,office.12).png

Bb332345.xlimgPivotFields_ZA10219206(en-us,office.12).png

Bb332345.xlimgPivotFilter_ZA10219207(en-us,office.12).png

Bb332345.xlimgPivotFilters_ZA10219208(en-us,office.12).png

Bb332345.xlimgPivotFormula_ZA10219209(en-us,office.12).png

Bb332345.xlimgPivotFormulas_ZA10219210(en-us,office.12).png

Bb332345.xlimgPivotItemList_ZA10219212(en-us,office.12).png

Bb332345.xlimgPivotItems_ZA10219213(en-us,office.12).png

Bb332345.xlimgPivotLayout_ZA10219214(en-us,office.12).png

Bb332345.xlimgPivotLine_ZA10219215(en-us,office.12).png

Bb332345.xlimgPivotLineCells_ZA10219216(en-us,office.12).png

Bb332345.xlimgPivotLines_ZA10219217(en-us,office.12).png

Bb332345.xlimgPivotTables_ZA10219219(en-us,office.12).png

Bb332345.xlimgPlotArea_ZA10219220(en-us,office.12).png

Bb332345.xlimgPoint_ZA10219221(en-us,office.12).png

Bb332345.xlimgPoints_ZA10219222(en-us,office.12).png

Bb332345.xlimgProtection_ZA10219223(en-us,office.12).png

Bb332345.xlimgPublishObject_ZA10219224(en-us,office.12).png

Bb332345.xlimgPublishObjects_ZA10219225(en-us,office.12).png

Bb332345.xlimgQueryTables_ZA10219227(en-us,office.12).png

Bb332345.xlimgRanges_ZA10219229(en-us,office.12).png

Bb332345.xlimgRectangularGradient_ZA10219232(en-us,office.12).png

Bb332345.xlimgResearch_ZA10219233(en-us,office.12).png

Bb332345.xlimgRoutingSlip_ZA10219234(en-us,office.12).png

Bb332345.xlimgScenario_ZA10219236(en-us,office.12).png

Bb332345.xlimgScenarios_ZA10219237(en-us,office.12).png

Bb332345.xlimgSeries_ZA10219238(en-us,office.12).png

Bb332345.xlimgSeriesCollection_ZA10219239(en-us,office.12).png

Bb332345.xlimgServerViewableItems_ZA10219241(en-us,office.12).png

Bb332345.xlimgShadowFormat_ZA10219242(en-us,office.12).png

Bb332345.xlimgShape_ZA10219243(en-us,office.12).png

Bb332345.xlimgShapeNode_ZA10219244(en-us,office.12).png

Bb332345.xlimgShapeNodes_ZA10219245(en-us,office.12).png

Bb332345.xlimgShapes_ZA10219247(en-us,office.12).png

Bb332345.xlimgSheetViews_ZA10219249(en-us,office.12).png

Bb332345.xlimgSmartTag_ZA10219250(en-us,office.12).png

Bb332345.xlimgSmartTagAction_ZA10219251(en-us,office.12).png

Bb332345.xlimgSmartTagActions_ZA10219252(en-us,office.12).png

Bb332345.xlimgSmartTagOptions_ZA10219253(en-us,office.12).png

Bb332345.xlimgSort_ZA10219257(en-us,office.12).png

Bb332345.xlimgSortField_ZA10219258(en-us,office.12).png

Bb332345.xlimgSortFields_ZA10219259(en-us,office.12).png

Bb332345.xlimgStyle_ZA10219263(en-us,office.12).png

Bb332345.xlimgStyles_ZA10219264(en-us,office.12).png

Bb332345.xlimgTab_ZA10219265(en-us,office.12).png

Bb332345.xlimgTableStyle_ZA10219266(en-us,office.12).png

Bb332345.xlimgTableStyleElement_ZA10219267(en-us,office.12).png

Bb332345.xlimgTableStyleElements_ZA10219268(en-us,office.12).png

Bb332345.xlimgTableStyles_ZA10219269(en-us,office.12).png

Bb332345.xlimgTextEffectFormat_ZA10219270(en-us,office.12).png

Bb332345.xlimgTextFrame_ZA10219271(en-us,office.12).png

Bb332345.xlimgTextFrame2_ZA10219272(en-us,office.12).png

Bb332345.xlimgThreeDFormat_ZA10219273(en-us,office.12).png

Bb332345.xlimgTop10_ZA10219275(en-us,office.12).png

Bb332345.xlimgTreeviewControl_ZA10219276(en-us,office.12).png

Bb332345.xlimgTrendline_ZA10219277(en-us,office.12).png

Bb332345.xlimgTrendlines_ZA10219278(en-us,office.12).png

Bb332345.xlimgUniqueValues_ZA10219279(en-us,office.12).png

Bb332345.xlimgUserAccess_ZA10219282(en-us,office.12).png

Bb332345.xlimgUserAccessList_ZA10219283(en-us,office.12).png

Bb332345.xlimgVPageBreak_ZA10219285(en-us,office.12).png

Bb332345.xlimgWalls_ZA10219287(en-us,office.12).png

Bb332345.xlimgWebOptions_ZA10219290(en-us,office.12).png

Bb332345.xlimgWorkbookConnection_ZA10219294(en-us,office.12).png

Bb332345.xlimgWorksheets_ZA10219299(en-us,office.12).png

Bb332345.xlimgWorksheetView_ZA10219300(en-us,office.12).png

Bb332345.xlimgXmlDataBinding_ZA10219301(en-us,office.12).png

Bb332345.xlimgXmlMap_ZA10219302(en-us,office.12).png

Bb332345.xlimgXmlMaps_ZA10219303(en-us,office.12).png

Bb332345.xlimgXmlNamespace_ZA10219304(en-us,office.12).png

Bb332345.xlimgXmlNamespaces_ZA10219305(en-us,office.12).png

Bb332345.xlimgXmlSchema_ZA10219306(en-us,office.12).png

Bb332345.xlimgXmlSchemas_ZA10219307(en-us,office.12).png

Legend
	Objects
	Collections
	New Objects
	New Collections

Tags

: Add a tag

Community Content

Add new content

Annotations

Graphical Object Model Map

AnandaSim ... Thomas Lee | Edit | Show History

Yes, the formerly excellent documentation in Excel since say Excel 5, has lost one major feature. The Object Model Map that used to be graphical with hyperlinks. In 2010, 2007 and 2003, the webpages are not serving us properly - one is missing the map, one just gives us a list of hyperlinks with no hierarchy, one has three entries....

For those that need the map, this download will extract to a .chm that you can use in the interim. It is for Excel 2003.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=2204a62e-4877-4563-8e83-4848dda796e4&;;amp;displaylang=en

Tags

: Add a tag

Flag as ContentBug

Unusable -runs off screen

Rohn007 ... Thomas Lee | Edit | Show History

This content looks like it has potential, but it is unreadable. It runs off the side of the screen with no horizontal scroll bar, huge vertical gaps between objects, every object appears to be duplicated. If there is a difference , I can't tell what it is.

Sad that MS would dare to post trashy pages like this.

Tags

: contentbug (x) Add a tag

This map is still not readable. I am sorry but I think that MS is losing their touch.

flipman2000 ... Thomas Lee | Edit | Show History

Somebody messed this map up and simply left it like this. They don't even seem to read their community content :)

Tags

: contentbug (x) Add a tag

workaround

Eddict | Edit | Show History

just use this link in (IE) browser, assuming Excel 2007 helpfile is installed...
ms-help://MS.EXCEL.DEV.12.1033/EXCEL.DEV/content/HV10219054.htm

Tags

: Add a tag

Flag as ContentBug

Reported readability issue through Give Feedback

Esther Fan | Edit | Show History

Sent through the Give Feedback mechanism on this page. Thanks.

Esther Fan, MSFT

Tags

: Add a tag

Flag as ContentBug

HELLOOOO!?!?

Spingolly | Edit | Show History

Does anyone test this type of stuff before they release it?!
I guess I should all be thankful that the 2007 dev. ref. at least has some content; 2003 ref. was completely blank!

Tags

: contentbug (x) Add a tag

This Resource is Unusable

WilliamSessums | Edit | Show History

I keep returning to these object models in hopes the problem will be resolved. I am saddened that the string of user comments seem to be going ignored.
Even if this is some Silverlight implementation that is not rendering correctly for me, there should be some alternate means of rendering this content in a meaningful way if only for accessibility reasons.

Tags

: contentbug (x) Add a tag

Where's the BEEF?

Stumple | Edit | Show History

I can't read this.

Tags

: contentbug (x) Add a tag

TreeView looks bad

Mike92 | Edit | Show History

I agree on the fact that the treeview is not very usable.

Tags

: contentbug (x) Add a tag

This page is unusable

dmercer | Edit | Show History

I concur. This page is unusable in its present state. It just doesn't render right in IE or Chrome.

Tags

: contentbug (x) Add a tag

Treeview not successfully rendered

OrgMulle | Edit | Show History

Hello,

this treeview of the object model is not successfully displayed... I tried IE7, IE8, Firefox 3.5 and Opera... In each browser I have big gaps between the items...

Any Ideas?

Thanks in advance

Bernhard

Tags

: contentbug (x) Add a tag