XL2000: #VALUE! in Spreadsheet Published from Excel When Transition Formula Evaluation Is Enabled

When you open a Web page in your browser that contains a Microsoft Office Spreadsheet, some formulas may display the #VALUE! error.

This problem may occur when the following conditions are true:

• The spreadsheet was published from data on a Microsoft Excel worksheet.
  
  -and-
  
  
• The Transition formula evaluation check box (on the Transition tab of the Options dialog box in Excel) was selected when you published the spreadsheet.

To resolve the problem, Follow these steps:

1. Open the Excel workbook that was used to publish the spreadsheet.
2. On the Tools menu, click Options.
3. On the Transition tab, click to clear the Transition formula evaluation check box, and then click OK.
   
   Some formulas will return the Transition formula evaluation error. See the "More Information" section later in this article for more information about how the Transition formula evaluation check box affects the calculation of your formulas.
4. On the File menu, click Save as Web Page.
5. Click Republish: Sheet, and then click Save.

The Transition formula evaluation option allows Excel to evaluate formulas in a manner consistent with Lotus 1-2-3. This option is enabled automatically when you open a file that was created in Lotus 1-2-3.

When the Transition formula evaluation check box is selected, Excel evaluates text strings as 0, converts Boolean expressions to 0 or 1, and converts database criteria according to the rules used in Lotus 1-2-3.

For more information about Transition Formula Evaluation, click Microsoft Excel Help on the Help menu, type Differences between Lotus 1-2-3 and Microsoft Excel functions in the Office Assistant or the Answer Wizard, and then click Search to view the topic.