XL2000: Errors Saving File to Earlier Formats (214274)

SYMPTOMS

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

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

-or-

A formula in cell cell address 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

REFERENCES

For more information about worksheet functions, click Microsoft Excel Help on the Help menu, type the name of the function in the Office Assistant or the Answer Wizard, and then click Search to view the topic.