XL2000: Page Setup Properties for Embedded Chart on Worksheet Lost After Saving as Web Page

When you open a workbook that you saved as HTML (click Save as Web Page on the File menu), custom Page Setup settings may change to the default values.

This problem may occur when the following conditions are true:

• The workbook contains embedded charts.
  
  -and-
  
  
• You select individual embedded charts and use Page Setup to create custom settings for printing the chart as its own document.
  
  -and-
  
  
• You make changes on the Page, Margins, or Header/Footer tabs.
  
  -and-
  
  
• You save the workbook as HTML, and then reopen it in Excel.

NOTE: When you save the workbook as HTML, Excel displays no warning that custom Page Setup information for embedded charts may be lost.

An embedded chart has its own set of Page Setup properties separate from the worksheet. Excel does not save the custom changes made on the Page, Margins, or Header/Footer tabs in Page Setup for an embedded chart when you save the workbook as HTML (in the .htm file format). However, Excel does save changes made to the Chart tab in Page Setup. Excel also saves similar changes in Page Setup that you make to a chart on its own sheet, after saving the file as HTML.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

To retain custom Page Setup settings for embedded charts, save the file as an Excel workbook (.xls).

For more information about saving a workbook as a Web page, click Microsoft Excel Help on the Help menu, type Put an entire workbook on a Web page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.