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

• Microsoft Excel 2000

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 this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

Example of the 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.

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug