microsoft.com Home
http://www.microsoft.com/office/ork |
|
microsoft.com Home
|
|
|
|
||
|
http://www.microsoft.com/office/ork |
|||
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. |
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
|