Functions Are Not Saved in Lotus 1-2-3 Format (162762)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
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: <cell ref>) 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: <cell ref>)
where <cell ref> 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.
REFERENCESMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kb3rdparty kberrmsg KB162762 |
|---|
|