Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Object Model Changes Since Microsoft Office 2000

Office 2007

The following is a summary of the changes in the Microsoft Office Excel 2007 object model as compared to Microsoft Office 2000.

Application

Properties Status
FileFind Hidden
FileSearch Hidden
MemoryFree Hidden
MemoryTotal Hidden
MemoryUsed Hidden
Methods Status
AddChartAutoFormat Hidden
DeleteChartAutoFormat Hidden
SetDefaultChart Hidden

AxisTitle

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

CalculatedFields

Methods Status
Add Changed

CalculatedItems

Methods Status
Add Changed

Chart

Properties Status
Area3DGroup Hidden
Bar3DGroup Hidden
Column3DGroup Hidden
Corners Hidden
HasPivotFields Hidden
Line3DGroup Hidden
Pie3DGroup Hidden
ProtectGoalSeek Hidden
Scripts Hidden
ShowWindow Hidden
SizeWithWindow Hidden
SurfaceGroup Hidden
WallsAndGridlines2D Hidden
Methods Status
ApplyCustomType Hidden
ApplyDataLabels Changed

AreaGroups Hidden
BarGroups Hidden
ColumnGroups Hidden
CreatePublisher Hidden
Deselect Hidden
DoughnutGroups Hidden
LineGroups Hidden
PieGroups Hidden
RadarGroups Hidden
SaveAs Changed

XYGroups Hidden
Events Status
DragOver Hidden
DragPlot Hidden

ChartArea

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

ChartColorFormat

Hidden

ChartFillFormat

Hidden

ChartObject

Properties Status
Border Hidden
Enabled Hidden
Interior Hidden

ChartObjects

Properties Status
Border Hidden
Enabled Hidden
Interior Hidden
RoundedCorners Hidden
Shadow Hidden
Methods Status
BringToFront Hidden
SendToBack Hidden

ChartTitle

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

Corners

Hidden

CubeField

Properties Status
Caption Changed

HiddenLevels Hidden

DataLabel

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Type Hidden

DataLabels

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Type Hidden

DataTable

Properties Status
AutoScaleFont Hidden

DisplayUnitLabel

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

DownBars

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Filter

Properties Status
Operator Changed

Floor

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Font

Properties Status
OutlineFont Hidden
Shadow Hidden

FormatCondition

Methods Status
Modify Changed

FormatConditions

Methods Status
Add Changed

Item Changed

Legend

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

LegendEntry

Properties Status
AutoScaleFont Hidden

LegendKey

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
Select Hidden

OLEObject

Properties Status
AltHTML Hidden

PageSetup

Properties Status
ChartSize Hidden

PivotCache

Methods Status
CreatePivotTable Changed

PivotCaches

Methods Status
Add Hidden

PivotField

Methods Status
AutoSort Changed

PivotFormulas

Methods Status
Add Changed

PivotLayout

Properties Status
ColumnFields Hidden
CubeFields Hidden
DataFields Hidden
HiddenFields Hidden
InnerDetail Hidden
PageFields Hidden
PivotCache Hidden
PivotFields Hidden
RowFields Hidden
VisibleFields Hidden
Methods Status
AddFields Hidden

PivotTable

Properties Status
HasAutoFormat Hidden
TableStyle Hidden
Methods Status
Format Hidden
PivotSelect Changed

PivotTables

Methods Status
Add Changed

PlotArea

Properties Status
Border Hidden
Fill Hidden
InsideHeight Changed

InsideLeft Changed

InsideTop Changed

InsideWidth Changed

Interior Hidden

Point

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
ApplyDataLabels Changed

QueryTable

Properties Status
TextFilePlatform Changed

Range

Properties Status
FormulaLabel Hidden
Value Changed

Methods Status
AutoFormat Hidden
CreatePublisher Hidden
Find Changed

GoalSeek Hidden
Insert Changed

Replace Changed

Sort Changed

SortSpecial Changed

TextToColumns Changed

Series

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
ApplyCustomType Hidden
ApplyDataLabels Changed

Shape

Properties Status
Script Hidden

Sheets

Methods Status
PrintOut Changed

TickLabels

Properties Status
AutoScaleFont Hidden

Trendline

Properties Status
Backward Hidden
Forward Hidden

UpBars

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Walls

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Workbook

Properties Status
AcceptLabelsInFormulas Hidden
HasRoutingSlip Hidden
HTMLProject Hidden
ReadOnlyRecommended Changed

Routed Hidden
RoutingSlip Hidden
Methods Status
PrintOut Changed

ProtectSharing Changed

Route Hidden
SaveAs Changed

Workbooks

Methods Status
Open Changed

OpenText Changed

Worksheet

Properties Status
Scripts Hidden
Methods Status
PasteSpecial Changed

PrintOut Changed

Protect Changed

SaveAs Changed

Worksheets

Methods Status
PrintOut Changed

XlDisplayShapes

Removed



Community Additions

Show: