Some workbook features not retained when saving as a Web page in Excel

Article translations Article translations
Article ID: 300637 - View products that this article applies to.
This article was previously published under Q300637
Expand all | Collapse all


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.
  • 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.


Article ID: 300637 - Last Review: May 24, 2007 - Revision: 3.0
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
kbprb KB300637

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from