Excel: Multiple Alerts Displayed When Closing WK3 file

 Last reviewed: November 30, 1994
Article ID: Q84277
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

SYMPTOMS

Saving and closing a WK3 file in Microsoft Excel may result in one or more instances of the following alert message: 

   Cannot write record (Name:PLY<PlyLetter>) Continue reporting errors?

CAUSE

This error message will occur if the WK3 file was created in Lotus 1-2-3 versions 3.x and contains globally defined names. To stop the alert from being displayed each time a record cannot be written, choose the No button in the alert box.

MORE INFORMATION

This stream of alerts is a result of the way Excel handles global names defined on WK3 worksheets. In Lotus 1-2-3, it is possible to define names that are global to all of the plys in a 3-D worksheet. To simulate this, Excel creates a number of temporary names when the WK3 file is opened and deletes them when the file is closed. This alert is displayed each time one of these temporary names is removed. The number of alerts depends on the number of plys and the number of global names defined on the WK3 worksheet.

The alert asks if you want Excel to continue reporting errors. By choosing No, Excel will complete closing your file without displaying the alert. Note that this method does not cause data to be lost.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 57, 61, 77

KBCategory: kberrmsg
KBSubcategory:

Additional reference words: 4.0 4.00 5.00 err msg

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: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.