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

SYMPTOMS

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.

CAUSE

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.

MORE INFORMATION

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.

Properties

Article ID: 300637 - Last Review: May 24, 2007 - Revision: 3.0
APPLIES TO
  • Microsoft Office Excel 2007
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
Keywords: 
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 smallbusiness.support.microsoft.com