XL2000: Formulas Unexpectedly Changed When Workbook Is Saved in the HTML File Format (231098)


The information in this article applies to:

  • Microsoft Excel 2000
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.

MORE INFORMATION

Example of the Problem

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

    Excel creates a workbook-level defined name called Testname.
  5. Select cell A2.
  6. Point to Name on the Insert menu and then click Define.
  7. 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.
  8. Type the following values into the worksheet: 
           A1: Workbook-level name
       A2: Worksheet-level name
       A3:
       A4: =Testname
    The formula in cell A4 correctly returns the value Worksheet-level name
  9. Click Save as Web Page on the File menu. Type Testname.htm in the File name box and then click Save.
  10. Click Close on the File menu.
  11. Open Testname.htm in your Web browser.

    The correct value is still displayed in what would be cell A4 in the worksheet.
  12. Open Testname.htm in Excel.

    Excel now displays the value Workboook-level name in cell A4.
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbbug kbpending KB231098
©2003 Microsoft Corporation. All rights reserved.