Article ID: 136733
Article Last Modified on 8/15/2003
APPLIES TO
- Microsoft Excel 97 Standard Edition
- Microsoft Excel 98 for Macintosh
This article was previously published under Q136733
This article also applies to:
- Microsoft Excel for Windows 95 7.0|7.0
- Microsoft Excel for Windows 5.0|5.0
- Microsoft Excel for Windows 5.0a|5.0a
- Microsoft Excel for Windows 5.0c|5.0c
- Microsoft Excel for Windows NT 5.0|5.0
- Microsoft Excel for the Macintosh 5.0|5.0
- Microsoft Excel for the Macintosh 5.0a|5.0a
SYMPTOMS
When you save a workbook in Microsoft Excel, you may receive one of the following error messages:
-or-
CAUSE
This error message may occur if both of the following conditions are true:
- The file is being saved 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 the formula "=VLOOKUP(1,B1:C5,2,TRUE)" (without the quotation marks) in a version 5.0 or 7.0 worksheet, and you try to save the worksheet as a Microsoft Excel 4.0 worksheet or workbook, you will receive the error message. Only the result of the function will be saved with the file. This error occurs because there isn't 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 Microsoft Excel version 5.0 and 7.0. 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
Microsoft Excel Version 7.0
For more information about worksheet functions in Microsoft Excel, click the Index tab in Microsoft Excel Help, type the following text
worksheet functions, index of functions
and then double-click the selected text to go to the "Worksheet Functions Listed by Category" topic.
Microsoft Excel Version 5.0
For more information about new and changed worksheet functions, click the Search button in Help and type:
new worksheet functions
Additional query words: XL
Keywords: kberrmsg kbprb KB136733