Article ID: 215281 - View products that this article applies to.
This article was previously published under Q215281
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.
Microsoft Excel cannot convert some of the cells. The total number of errors found is 3.
Where Filename is the name of the file that you are saving and File format is the file format in which you are saving the file.
Filename may contain features that are not compatible with File format. Do you want to keep the workbook in this format?
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:
This problem occurs when the following conditions are true:
To work around the problem, use either of the following methods.
Method 1: Disable Transition Formula EvaluationTo disable Transition Formula Evaluation, follow these steps:
Method 2: Use the Corresponding "A" FunctionFor 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:
(http://support.microsoft.com/kb/205548/EN-US/ )XL2000: Using A Functions in Microsoft Excel 2000
Contact us for more help
Connect with Answer Desk for expert help.