XL: Cell Notes Corrupted If Paste Range Overlaps Copy Range

 Last reviewed: September 13, 1996
Article ID: Q139132
The information in this article applies to:
  • Microsoft Excel for Windows, version 5.0
  • Microsoft Excel for the Macintosh, version 5.0
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, cell notes may become corrupted when one worksheet cell has multiple notes. In addition ,the following error may be displayed when you open the file: 

   File Error: data may have been lost.
After this error message occurs, cell notes will be incorrect or lost.

CAUSE

This problem occurs you copy and paste cells with notes such that some cells overlap in the copy and paste ranges.

RESOLUTION

To avoid this problem, make sure that when you copy and paste cells with notes, that you paste the copied cells to a non-overlapping range. Note that once you do this, you can then copy from that range and paste to the desired range.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel version 5.0 for Windows, Microsoft Excel version 5.0 for Windows NT and Microsoft Excel version 5.0 for the Macintosh. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

REFERENCES

For more information about cell notes, click the Index tab in Microsoft Excel 7.0 Help, type the following text 

   notes, cell
and then double-click the text that most resembles the topic you are interested in.

"Microsoft Excel User's Guide," version 5.0, pages 675-677

KBCategory: kbprb kberrmsg
KBSubcategory:

Additional reference words: 5.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: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.