Microsoft KB Archive/215281

= XL2000: Errors Saving to an Earlier File Format When Transition Formula Evaluation Is Enabled =

Article ID: 215281

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215281





SYMPTOMS
When you save your file, you receive one or more error messages similar to the following:

A formula in a cell (Cell:B7) could not be converted because it contains a function that is not available in the file format to which you are saving. If you continue the save, the formula and result will be saved, but the function itself will be converted to an error value.

followed by:

Microsoft Excel cannot convert some of the cells. The total number of errors found is 3.

followed by:

may contain features that are not compatible with. Do you want to keep the workbook in this format?

Where  is the name of the file that you are saving and   is the file format in which you are saving the file.

If you choose to save the file following these error messages, then when you reopen the file, Excel will convert the formula in the cells referenced to:   =#N/A



CAUSE
This problem occurs when the following conditions are true:  You saved your file to one of the following file formats:

 Microsoft Excel 5.0/95 Workbook Microsoft Excel 97-2000 & 5.0/95 Workbook Microsoft Excel 4.0 Worksheet Microsoft Excel 4.0 Workbook</ul>

-and-

</li> Your worksheet contains any of the following functions:

<ul> AVERAGE</li> MIN</li> MAX</li> STDEV</li> STDEVP</li> VAR</li> VARP</li></ul>

-and-

</li> The Transition formula evaluation check box on the Transition tab of the Options dialog box is selected.</li></ul>

<div class="workaround_section">

WORKAROUND
To work around the problem, use either of the following methods.

Method 1: Disable Transition Formula Evaluation
To disable Transition Formula Evaluation, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) On the Transition tab, click to clear the Transition formula evaluation check box, and then click OK.

Method 2: Use the Corresponding "A" Function
For each of the functions listed in the "Cause" section of this article, Excel includes a set of functions that are designed to be 100 percent compatible with Lotus 1-2-3. These functions are known as the "A" functions because all of the function names end with the letter A.

For additional information about using the A functions, please see the following article in the Microsoft Knowledge Base:

205548 XL2000: Using A Functions in Microsoft Excel 2000

Additional query words: XL2000

Keywords: kbprb KB215281

-

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

© Microsoft Corporation. All rights reserved.