Microsoft KB Archive/221500

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

Article ID: 221500

Article Last Modified on 10/28/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q221500



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 that this is a problem in the Microsoft products that are 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).

