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

ID: Q221500

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

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.

CAUSE

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.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

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

For additional information about features that are lost when you save your workbook in the HTML file format, please see the following article in the Microsoft Knowledge Base:

Q202283 XL2000: Some Workbook Features Not Retained When Saving as a Web Page

REFERENCES

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.

Additional query words: XL2000

Keywords : kbconversion kbchart
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug