Properties and methods that have been added to existing objects in Microsoft Excel 97 are listed in the following table (sorted alphabetically by property or method name). For more information about the changes to the Microsoft Excel 97 object model, see one of the following topics:
New Properties and Methods (by Object)
Changes to Visual Basic in Microsoft Excel for Windows 95
| New property or method | Objects |
|---|---|
| AcceptAllChanges Method | Workbook |
| AcceptLabelsInFormulas Property | Workbook |
| Add Method | PivotItems |
| AddComment Method | Range |
| AddToFavorites Method | Workbook |
| ApplyCustomType Method | Chart, Series |
| ApplyPictToEnd Property | Point, Series |
| ApplyPictToFront Property | Point, Series |
| ApplyPictToSides Property | Point, Series |
| Assistant Property | Application |
| AutoLoad Property | OLEObjects |
| AutoScaleFont Property | AxisTitle, ChartArea, ChartTitle, DataLabel, DataLabels, Legend, LegendEntry, TickLabels |
| AutoShow Method | PivotField |
| AutoShowCount Property | PivotField |
| AutoShowField Property | PivotField |
| AutoShowRange Property | PivotField |
| AutoShowType Property | PivotField |
| AutoSort Method | PivotField |
| AutoSortField Property | PivotField |
| AutoSortOrder Property | PivotField |
| AutoUpdateFrequency Property | Workbook |
| AutoUpdateSaveChanges Property | Workbook |
| BarShape Property | Chart, Series |
| BaseUnit Property | Axis |
| BaseUnitIsAuto Property | Axis |
| BubbleScale Property | ChartGroup |
| BubbleSizes Property | Series |
| BuiltIn Property | Style |
| CacheIndex Property | PivotTable |
| CalculatedFields Method | PivotTable |
| CalculatedItems Method | PivotField |
| CategoryType Property | Axis |
| ChangeHistoryDuration Property | Workbook |
| ChartType Property | Chart, Series |
| CircleInvalid Method | Worksheet |
| Clear Method | Legend |
| ClearCircles Method | Worksheet |
| ClearComments Method | Range |
| CodeName Property | Chart, Workbook, Worksheet |
| CommandBars Property | Application, Workbook |
| Comment Property | Range |
| Comments Property | Worksheet |
| ConflictResolution Property | Workbook |
| ControlCharacters Property | Application |
| CorrectCapsLock Property | AutoCorrect |
| CorrectSentenceCap Property | AutoCorrect |
| CursorMovement Property | Application |
| CustomViews Property | Workbook |
| DataTable Property | Chart |
| DefaultSaveFormat Property | Application |
| DefaultSheetDirection Property | Application |
| Delete Method | PivotField, PivotItem |
| DisplayCommentIndicator Property | Application |
| DisplayErrorString Property | PivotTable |
| DisplayNullString Property | PivotTable |
| DisplayPageBreaks Property | Worksheet |
| DisplayRightToLeft Property | Worksheet |
| DragToColumn Property | PivotField |
| DragToHide Property | PivotField |
| DragToPage Property | PivotField |
| DragToRow Property | PivotField |
| EnableCalculation Property | Worksheet |
| EnableDrilldown Property | PivotTable |
| EnableEvents Property | Application |
| EnableFieldDialog Property | PivotTable |
| EnableResize Property | Window |
| EnableSelection Property | Worksheet |
| EnableSound Property | Application |
| EnableWizard Property | PivotTable |
| ErrorString Property | PivotTable |
| Export Method | Chart |
| FileSearch Property | Application |
| Fill Property | AxisTitle, ChartArea, ChartTitle, DataLabel, DataLabels, DownBars, Floor, Legend, LegendKey, PlotArea, Point, Series, UpBars, Walls |
| FollowHyperlink Method | Workbook |
| FormatConditions Property | Range |
| Formula Property | PivotField, PivotItem |
| FormulaLabel Property | Range |
| GetChartElement Method | Chart |
| GetData Method | PivotTable |
| Has3DEffect Property | Series |
| Has3DShading Property | ChartGroup |
| HasDataTable Property | Chart |
| HasLeaderLines Property | Series |
| Height Property | Axis, LegendEntry, LegendKey |
| HighlightChangesOnScreen Property | Workbook |
| HighlightChangesOptions Method | Workbook |
| HPageBreaks Property | Charts, Sheets, Worksheet, Worksheets |
| Hyperlinks Property | Chart, Range, Worksheet |
| IndentLevel Property | Range, Style |
| Index Property | ChartGroup |
| InsertIndent Method | Range |
| InsideHeight Property | PlotArea |
| InsideLeft Property | PlotArea |
| InsideTop Property | PlotArea |
| InsideWidth Property | PlotArea |
| InvertIfNegative Property | Interior |
| IsAddin Property | Workbook |
| IsCalculated Property | PivotField, PivotItem |
| KeepChangeHistory Property | Workbook |
| LeaderLines Property | Series |
| Left Property | Axis, LegendEntry, LegendKey |
| LinkedCell Property | OLEObject |
| ListChangesOnNewSheet Property | Workbook |
| ListFillRange Property | OLEObject |
| ListFormulas Method | PivotTable |
| Location Method | Chart |
| MajorUnitScale Property | Axis |
| ManualUpdate Property | PivotTable |
| MarkerSize Property | LegendKey, Point, Series |
| MemoryUsed Property | PivotField |
| Merge Method | Range |
| MergeArea Property | Range |
| MergeCells Property | Range, Style |
| MergeLabels Property | PivotTable |
| MergeWorkbook Method | Workbook |
| MinorUnitScale Property | Axis |
| NewSeries Method | SeriesCollection |
| NullString Property | PivotTable |
| ODBCErrors Property | Application |
| ODBCTimeout Property | Application |
| PageFieldOrder Property | PivotTable |
| PageFieldStyle Property | PivotTable |
| PageFieldWrapCount Property | PivotTable |
| PageRangeCells Property | PivotTable |
| Paste Method | Floor, Walls |
| PersonalViewListSettings Property | Workbook |
| PersonalViewPrintSettings Property | Workbook |
| PictureType Property | Floor, LegendKey, Walls |
| PictureUnit Property | LegendKey, Walls |
| PivotCache Method | PivotTable |
| PivotCaches Method | Workbook |
| PivotFormulas Property | PivotTable |
| PivotSelect Method | PivotTable |
| PivotSelection Property | PivotTable |
| PivotTableSelection Property | Application |
| PivotTableWizard Method | PivotTable |
| PlotBy Property | Chart |
| Position Property | DataLabel, DataLabels |
| PreserveFormatting Property | PivotTable |
| PrintComments Property | PageSetup |
| ProgId Property | OLEObject |
| ProtectChartObject Property | ChartObject |
| ProtectData Property | Chart |
| ProtectFormatting Property | Chart |
| ProtectGoalSeek Property | Chart |
| ProtectSelection Property | Chart |
| ProtectSharing Method | Workbook |
| PurgeChangeHistoryNow Method | Workbook |
| QueryTable Property | Range |
| QueryTables Property | Worksheet |
| ReadingOrder Property | AxisTitle, ChartTitle, DataLabel, DataLabels, Range, Style, TickLabels |
| RecentFiles Property | Application |
| RecordCount Property | PivotItem |
| Refresh Method | Chart |
| RefreshAll Method | Workbook |
| RejectAllChanges Method | Workbook |
| RemoveUser Method | Workbook |
| ResetAllPageBreaks Method | Worksheet |
| ResetColors Method | Workbook |
| RollZoom Property | Application |
| SaveWorkspace Method | Application |
| ScrollArea Property | Worksheet |
| SecondaryPlot Property | Point |
| SecondPlotSize Property | ChartGroup |
| SelectionMode Property | PivotTable |
| ServerBased Property | PivotField |
| SetSourceData Method | Chart |
| Shadow Property | LegendKey, Point, Series |
| ShapeRange Property | ChartObject, ChartObjects, OLEObject, OLEObjects |
| Shapes Property | Chart, Worksheet |
| ShowAllItems Property | PivotField |
| ShowChartTipNames Property | Application |
| ShowChartTipValues Property | Application |
| ShowNegativeBubbles Property | ChartGroup |
| ShowWindow Property | Chart |
| ShrinkToFit Property | Range, Style |
| SizeRepresents Property | ChartGroup |
| SourceName Property | OLEObject, OLEObjects |
| SplitType Property | ChartGroup |
| SplitValue Property | ChartGroup |
| SubtotalHiddenPageItems Property | PivotTable |
| TableStyle Property | PivotTable |
| Tag Property | PivotTable |
| TemplateRemoveExtData Property | Workbook |
| Top Property | Axis, LegendEntry, LegendKey |
| UnMerge Method | Range |
| UnprotectSharing Method | Workbook |
| Update Method | PivotTable |
| UserControl Property | Application, Workbook |
| VacatedStyle Property | PivotTable |
| Validation Property | Range |
| Value2 Property | Range |
| VBE Property | Application |
| VBProject Property | Workbook |
| View Property | Window |
| VPageBreaks Property | Charts, Sheets, Worksheet, Worksheets |
| Width Property | Axis, LegendEntry, LegendKey |
| WorksheetFunction Property | Application |