Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Office 2000 Resource Kit
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Saving Workbooks in Excel 98 and Excel 97
 
Upgrading to Excel 2000

When Microsoft Excel 2000 users save workbooks in Excel 97-2000 format, all worksheet and chart data, formatting, macros, and other Excel 2000 features are preserved in Excel 98 (Macintosh) and Excel 97 (Windows). However, if an Excel 98 or Excel 97 user saves the workbook in an earlier file format, some formatting and data might be lost.


System Policy Tip   You can use a system policy to define the default value for the Save as type option in the Save As dialog box (File menu). In the System Policy Editor, set the Microsoft Excel 2000\Tools | Options\Transition\Save Excel files as policy. For more information about the System Policy Editor, see Using the System Policy Editor.


The following table describes new features in Excel 2000 that might affect your data or formatting in Excel 98 and Excel 97.

When this Excel 2000 feature Is saved in Excel 98 or Excel 97 format
External data ranges Auto-refresh, column formatting, filtering, and sorting do not work.
Indented format PivotTable reports If edited, reports change to nonindented layout but maintain character and cell formatting.
OLAP PivotTable and PivotChart reports Appear as read-only.
PivotChart reports Appear as regular charts. Multiple-level category labels are modified, and value axis display units convert to literal values.

See also

You can specify the default format in which Excel 2000 saves a new workbook. For more information, see How to Specify the Default Format in Which to Save Files.

advertisement