XL2000: Errors Saving File to Earlier Formats

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

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
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.

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.

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
				

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.