Cell Notes Corrupted If Paste Range Overlaps Copy Range This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
This article was previously published under Q139132 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 APPLIES TO
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Help and Support
Back to the top
|
