Microsoft KB Archive/185415

= XL98: Functions Are Not Saved in Lotus 1-2-3 Format =

Article ID: 185415

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q185415



SYMPTOMS
In Microsoft Excel, when you save a workbook in the Lotus 1-2-3 WK3 or WK4 format, you may receive one of the following error messages:

A formula in cell (Cell: ) could not be converted because it contains a function that is not available in the format to which you are saving. If you continue the 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 so you can fix them later?

When you open the file that you saved in the Lotus 1-2-3 format, the cell that previously contained a formula contains only the value that appeared when you saved the workbook.

For additional information, please see the following articles in the Microsoft Knowledge Base:

123261 XL: Formulas Failed to Convert Error Opening WK4 File

176802 XL98: Values Incorrect When Formulas Saved in WK3 or WK4 Format

185312 XL98: Function Values Change When You Save in Lotus 1-2-3 Format



CAUSE
This problem occurs if your workbook contains any of the following Microsoft Excel worksheet functions:   AREAS DOLLAR DPRODUCT FACT FREQUENCY GETPIVOTDATA GROWTH HYPERLINK IPMT ISBLANK ISERROR ISLOGICAL LINEST LOGEST LOOKUP MATCH MDETERM MINVERSE MIRR MMULT PPMT PRODUCT SEARCH SUBSTITUTE TEXT TRANSPOSE TREND TYPE WEEKDAY



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98.

