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.
↑ Back to the top
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.
↑ Back to the top
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.
- Scenarios.
- 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:
- Strikethrough
- Superscript
- Subscript
- 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.
↑ Back to the top