Article ID: 211444
Article Last Modified on 10/6/2003
APPLIES TO
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q211444
SYMPTOMS
In Microsoft Excel 2000, when you save a workbook in an earlier format, such as any of the following formats
- Microsoft Excel 5.0/95 Workbook
- Microsoft Excel 4.0 Worksheet
- Microsoft Excel 3.0 Worksheet
- Microsoft Excel 2.1 Worksheet
you may receive multiple error messages similar to the following:
-and-
-and-
CAUSE
You receive these error messages if either of the following conditions is true:
- The workbook or worksheet that you are saving contains formulas that use functions that do not exist in the earlier version of Microsoft Excel.
-or-
- Functions in your formulas refer to arguments that do not exist in the earlier version of Microsoft Excel.
MORE INFORMATION
If the workbook or worksheet contains functions or arguments that are not supported in earlier versions of Microsoft Excel, you receive the error messages in the "Symptoms" section of this article when you save a file in a file format of an earlier version of Microsoft Excel.
If you save the file in the format of an earlier version, save a copy of the workbook in the Microsoft Excel Workbook format (for Microsoft Excel 2000). This step ensures that you do not permanently lose any of your formulas or formatting.
The worksheet functions that are available in Microsoft Excel 2000 and are not available in earlier versions of Microsoft Excel are specified in the following table.
Function 7.0 5.0 4.0 ------------------------------ AMORDEGRC x AMORLINC x AVERAGEA x x x CONCATENATE x COUNTBLANK x COUNTIF x GETPIVOTDATA x x x HYPERLINK x x x ISPMT x MAXA x x x MINA x x x POWER x ROMAN x ROUNDDOWN x ROUNDUP x SQLREQUEST x STDEVA x x x STDEVPA x x x SUBTOTAL x SUMIF x VARA x x x VARPA x x x
In addition, other functions such as VLOOKUP, HLOOKUP, DAYS360, and WEEKDAY, accept more arguments in Excel 2000 than they do in versions of Excel earlier than Excel 97.
The "Cannot Convert" Error Message
The "Microsoft Excel cannot convert some of the cells" error message reports a varying number of errors. This number depends on the file format in which you save the workbook or worksheet. This behavior occurs for the following reasons:
- Functions and arguments that are supported in one earlier version of Microsoft Excel (for example, version 5.0) may not be supported in another earlier version of Microsoft Excel (for example, version 4.0).
- Depending on how you enter formulas in your worksheets, some cells that contain unsupported functions or arguments may not be reported. This behavior occurs if any of the cells that contain the formulas are using "shared" formulas. If cells contain shared formulas, the number reported by the error message may be smaller than expected.
The difference in the number of reported cells is not cause for concern; however, you should be aware of the difference. Make sure you save a copy of the workbook in the Microsoft Excel Workbook format to avoid losing formulas and formatting.
Additional query words: XL2000
Keywords: kberrmsg kbprb KB211444