microsoft.com Home  
Microsoft
http://www.microsoft.com/office/ork  
Upgrading to Excel 2000

Saving Workbooks in Excel 98 and Excel 97

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.

Top

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.



Topic Contents   |   Previous   |   Next   |   Top

Friday, March 5, 1999
© 1999 Microsoft Corporation. All rights reserved. Terms of use.

License