XL2002: "Save Any Additional Hidden Data" Web Option Does Not Function as Expected (287077)


The information in this article applies to:

  • Microsoft Excel 2002
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.
Modification Type:MajorLast Reviewed:3/27/2001
Keywords:kbbug KB287077
©2002 Microsoft Corporation. All rights reserved.