Microsoft KB Archive/287077

= XL2002: &quot;Save Any Additional Hidden Data&quot; Web Option Does Not Function as Expected =

Article ID: 287077

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q287077





SYMPTOMS
In Microsoft Excel, when you click to clear the Save any additional hidden data necessary to maintain formulas check box (on the General tab in the Web Options dialog box), and then you save a worksheet as a Web page, the references that a formula uses unexpectedly remain in the Web page.

When you click to select the Save any additional hidden data necessary to maintain formulas check box, and then you publish selected cells to an interactive Web page, any cells that are referenced by the cells in the interactive Web page do not appear in the Web page as expected.

The Save any additional hidden data necessary to maintain formulas check box appears to have no function.



WORKAROUND
To work around this issue, publish all of the cells that contain any data or formulas to an interactive Web page when an Excel worksheet contains formulas that reference other cells.



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 save an Excel worksheet as a Web page, follow these steps:
 * 1) Start Excel, and then open the workbook that contains the worksheet that you want to publish as a Web page.
 * 2) Select the worksheet that you want.
 * 3) On the File menu, click Save as Web Page.
 * 4) Click Entire Workbook or Selection, and then click Save.

To save cells in an Excel worksheet as a interactive Web page, follow these steps:
 * 1) Start Excel, and then open the workbook that contains the worksheet that you want.
 * 2) Select the cells that you want to publish as an interactive Web page.
 * 3) On the File menu, click Save as Web Page.
 * 4) Click Selection.
 * 5) Click to select the Add interactivity check box, and then click Save.

To select or clear the Save any additional hidden data necessary to maintain formulas check box, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) In the Options dialog box, click the General tab.
 * 3) Click Web Options.
 * 4) In the Web Options dialog box, click the General tab.
 * 5) Click to select or clear the Save any additional hidden data necessary to maintain formulas check box, and then click OK twice.

Additional query words: XL2002

Keywords: kbbug kbpending KB287077

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.