Microsoft KB Archive/215535

= XL2000: Error During Save Identifies Incorrect Cell for Function =

Article ID: 215535

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q215535



SYMPTOMS
When you save a workbook in an older file format you may receive the following error message, which incorrectly identifies the cell in which a function resides:

A formula in a cell (Name: ) 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.

Do you want to see additional errors as they occur so you can fix them later?

where  is the last defined name, alphabetically, in your workbook.

If you click Yes the error message reappears, but  is replaced with a cell reference.



CAUSE
This error message occurs when all of the following conditions are true:


 * There are one or more defined names in the workbook.

-and-


 * There are one or more functions in the workbook that cannot be saved in the older file format.

-and-


 * You save your workbook in an earlier version file format, for example, as a Microsoft Excel 5.0/95 Workbook.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
Excel 2000 introduces new spreadsheet functions that are not supported in Microsoft Excel 95 for Windows or Microsoft Excel, version 5.0. These functions include the following:

AVERAGEA

MAXA

MINA

STDEVA

STDEVPA

VARA

VARPA

HYPERLINK

GETPIVOTDATA

In this situation, Excel calculates the function before saving the file and replaces the formula with the resulting value. However, the HYPERLINK function is resolved to the value =#N/A.

