Microsoft KB Archive/211965

= XL2000: Data Overwritten Copying More Than 31,737 Characters =

Article ID: 211965

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211965





SYMPTOMS
When you copy more than 31,737 characters, and then paste them in another cell, Microsoft Excel pastes only 31,737 characters. The remaining characters are pasted into the cell below the cell that contains the 31,737 characters. Microsoft Excel automatically overwrites data that exists in this cell without warning.



CAUSE
This problem occurs when the following conditions are true:
 * You double-click a cell or press F2 to activate edit mode. -and-


 * The cell you are editing contains more than 31,737 characters. -and-


 * You select and copy more than 31,737 characters in the cell, and then paste the characters in another cell.

This problem occurs because the limit for the number of characters that you can import through the Clipboard is 31,737.

NOTE: This problem occurs only if you are in edit mode when you copy more than 31,737 characters.



RESOLUTION
To copy more than 31,737 characters from one cell to another, first copy and paste the entire cell contents, and then delete any unwanted characters in the destination cell.

Step 1: Copy and Paste the Entire Cell Contents

 * 1) Select the cell that contains the characters that you want to copy.NOTE: Do not double-click the cell or press F2 because this activates edit mode.


 * 1) On the Edit menu, click Copy.
 * 2) Select the destination cell, and then click Paste on the Edit menu.

Step 2: Delete Any Unwanted Characters in the Destination Cell

 * 1) Double-click the destination cell or press F2 to activate edit mode.
 * 2) Select the unwanted characters in the destination cell, and then press DELETE.
 * 3) After you delete the unwanted characters, press ENTER.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: clip board ole specification overwritten XL2000

Keywords: kbbug kbpending KB211965

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.