Microsoft KB Archive/162762

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

Article ID: 162762

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



This article was previously published under Q162762



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

Microsoft Excel 97

--

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?

Microsoft Excel 5.0 and 7.0

---

Cannot write record. (Cell: )

where is a worksheet cell reference.

When you open the file 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

111981 XL: Functions Not Saved to Quattro Pro File 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 the versions of Microsoft Excel listed at the beginning of this article.



Microsoft Excel 97
For more information about Lotus 1-2-3, click the Index tab in Microsoft Excel Help, type the following text

lotus 1-2-3, converting files

and then double-click the selected text to go to the "View or save files from other programs as Microsoft Excel workbooks" topic.

Microsoft Excel 5.0 or 7.0
For more information about opening Lotus 1-2-3 files in Microsoft Excel 5.0 or 7.0, click the Search button in Help and type:

lotus 1-2-3, converting files

Lotus 1-2-3 is manufactured by Lotus, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: 97 XL

Keywords: kberrmsg kb3rdparty KB162762

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.