Knowledge Base

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:defined 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 defined name is the last defined name, alphabetically, in your workbook.

If you click Yes the error message reappears, but defined name 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.

REFERENCES

For more information about new worksheet functions and features not supported in the Microsoft Excel 5.0/95 file format, click Microsoft Excel Help on the Help menu, type Features not transferred in file conversions in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: XL2000

Keywords: kbbug kbpending KB215535

Microsoft KB Archive/215535

Contents