Microsoft KB Archive/231098

= XL2000: Formulas Unexpectedly Changed When Workbook Is Saved in the HTML File Format =

Article ID: 231098

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q231098



SYMPTOMS
When you open a workbook, one or more cells contain the wrong value. Formulas that previously referred to a sheet-level defined name now refer to a workbook-level defined name.



CAUSE
This problem occurs when the following conditions are true:


 * The workbook is saved in the HTML file format.

-and-


 * The workbook contains both a sheet-level defined name and a workbook-level defined name with the same name. For example, the workbook contains a both sheet-level and a workbook-level defined name called "Test".

-and-


 * One or more formulas in the workbook referred to the sheet-level defined name when you saved the workbook in the HTML file format.



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



Example of the Problem
Follow these steps to see an example of this problem:  Save and close any open workbooks and create a new workbook. Select cell A1. Point to Name on the Insert menu and then click Define. Type Testname and then click Add. Click OK to dismiss the Define Name dialog box.

Excel creates a workbook-level defined name called Testname. Select cell A2. Point to Name on the Insert menu and then click Define.</li> Type Sheet1!Testname and then click Add. Click OK to dismiss the Define Name dialog box.

Excel creates a sheet-level defined name called Testname.</li>  Type the following values into the worksheet: <pre class="fixed_text">      A1: Workbook-level name A2: Worksheet-level name A3: A4: =Testname The formula in cell A4 correctly returns the value Worksheet-level name </li> Click Save as Web Page on the File menu. Type Testname.htm in the File name box and then click Save.</li> Click Close on the File menu.</li> Open Testname.htm in your Web browser.

The correct value is still displayed in what would be cell A4 in the worksheet.</li> Open Testname.htm in Excel.

Excel now displays the value Workboook-level name in cell A4.</li></ol>

Additional query words: XL2000

Keywords: kbbug kbpending KB231098

-

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

© Microsoft Corporation. All rights reserved.