Some workbook features not retained when saving as a Web page in Excel
This article has been archived. It is offered "as is" and will no longer be updated.
When you open a Microsoft Excel workbook file that has been saved as a Web page, some elements that were present in the original Excel workbook may be lost.
Although Excel retains most workbook features when you save a workbook as a Web page and then reopen it in Excel, some features are lost. This behavior is by design.
The following features are not retained when you save your entire workbook as a Web page:
- Custom views.
- Unused number formats.
- Unused styles.
- Data Consolidation settings.
- Natural Language Formulas.
Natural language formulas are converted to standard range references.
- Multiple windows.
If your workbook was set to display more than one window, only one window is displayed when you open the HTML file.
- Function Categories.
All user-defined functions appear in the User Defined function category in the Paste Function dialog box.
- Shared workbooks are no longer shared.
The change history is lost when you save your workbook as a Web page and the workbook is no longer shared.
- The Value (Y) axis crosses at category number setting on the scale tab of the Format Axis dialog box is not saved if the Value (Y) axis crosses a maximum category check box is selected.
- The Vary colors by point setting in the Format Data Series dialog box is not saved if the chart contains more than one data series.
- Customized Page Setup settings for charts that are embedded on a worksheet are not saved.
- The following font formatting elements in Styles are not saved:
- List boxes and combo boxes created by using the Forms toolbar may lose their list settings.
- Conditional formatting that is stored on an XLM style macro sheet.
roundtrip round-trip roundtripping xml prb XL2002 XL2000 XL2003 XL2007
Article ID: 300637 - Last Review: 01/12/2015 18:18:57 - Revision: 4.0
Microsoft Office Excel 2007
Microsoft Excel 2002 Standard Edition
Microsoft Excel 2000 Standard Edition
kbnosurvey kbarchive kbprb KB300637