Microsoft KB Archive/214274

= XL2000: Errors Saving File to Earlier Formats =

Article ID: 214274

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214274





SYMPTOMS
When you save a workbook in Microsoft Excel 2000, you may receive one of the following error messages:

Cannot write record (Cell: ), Continue reporting each error?

-or-

A formula in cell  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 to 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 if you can fix them later?


 * To see each error as it occurs, click Yes.
 * To get only a count of the number of errors when Microsoft Excel is finished saving, click No.
 * To cancel the Save, click Cancel.

Continue to report each error?



CAUSE
This issue can occur when both of the following conditions are true:
 * You are saving the file in a Microsoft Excel version 4.0 or earlier format.

-and-
 * There are functions in the workbook that use arguments that are not available in the Microsoft Excel format you are saving to.

For example, if you are using this formula

=VLOOKUP(1,B1:C5,2,TRUE)

in an Excel version 5.0 or 7.0 worksheet, and you try to save the worksheet as a version 4.0 worksheet or workbook, you receive an error message. Only the result of the function is saved with the file. This error occurs because there is not a fourth argument to the VLOOKUP function in Microsoft Excel versions 4.0 and earlier.



WORKAROUND
To work around this problem, change all of the formulas that have functions with arguments not found in earlier versions to the appropriate format for the earlier version.



MORE INFORMATION
There are many functions that have changed since Microsoft Excel version 4.0, and there are some new functions both in Excel versions 5.0 and 7.0 and later. The following table lists the worksheet functions that have either changed since version 4.0 or were not part of the version 4.0 list of worksheet functions.                           Changed since      New since Function               version 4.0        version 4.0 --  SQLREQUEST                                 x   SUBTOTAL                                   x   DAYS360                   x   WEEKDAY                   x   YEARFRAC                  x   AMORDEGRC                                  x   AMORLINC                                   x   COUNTBLANK                                 x   HLOOKUP                   x   VLOOKUP                   x   COUNTIF                                    x   POWER                                      x   ROMAN                                      x   ROUNDDOWN                                  x   ROUNDUP                                    x   SUMIF                                      x   CONCATENATE                                x

