XL Err Msg: "Cannot Write Record" with WKS, WK1, or WK3 Format

Last reviewed: August 30, 1995
Article ID: Q78647
The information in this article applies to:
  • Microsoft Excel for Windows, version 2.x, 3.0, 4.x, 5.0
  • Microsoft Excel for the Macintosh, version 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, version 2.2, 3.0

SUMMARY

Microsoft Excel may display the error message "Cannot write record" if Excel translates a worksheet into WKS, WK1, or WK3 file formats. Microsoft Excel returns this error for elements of a worksheet that cannot be successfully translated.

If the error occurs, Microsoft Excel saves the file, but the information that generated the error message may not translate correctly because the information involves a feature of Microsoft Excel that is not supported in the Lotus format.

MORE INFORMATION

To avoid the error, either remove the information that caused the error, or save the file in the Normal format. The following conditions are known to produce this error:

  1. Defined names longer than 15 characters.

  2. Defined names that refer to a multiple regions.

  3. Defined names that refer to relative references.

  4. Defined names that refer to text strings.

  5. Cells that refer to undefined names.

  6. The worksheet contains a TABLE function.

  7. Links are established.

  8. Formulas that contain parameters or arguments that are invalid or illegal in the WK3, WK1, or WKS file formats.

NOTE: Microsoft Excel versions 3.0 and later save and open WKS, WK1, and WK3 file formats. Microsoft Excel 2.2 and earlier versions support only WKS and WK1.

REFERENCES

"User's Guide," version 4.0, page 45 "User's Guide," version 3.0, pages 133-135


KBCategory: kberrmsg kb3rdparty
KBSubcategory:

Additional reference words: 2.1 2.10 2.2 2.20 2.21 3.0 3.00 4.0
4.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 30, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.