Microsoft KB Archive/221470

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

Article ID: 221470

Article Last Modified on 2/23/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Office Spreadsheet Component 9.0, run time

-



This article was previously published under Q221470



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



CAUSE
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.



RESOLUTION
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.
 * 1) On the File menu, click Save as Web Page.
 * 2) Click Republish: Sheet, and then click Save.



MORE INFORMATION
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.

Additional query words: XL2000 webcalc tfe

Keywords: kbprb kbpending KB221470

-

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

© Microsoft Corporation. All rights reserved.