Microsoft KB Archive/228868

= XL2000: Hidden Property Not Retained When Pasting Selection from Word =

Article ID: 228868

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q228868



SYMPTOMS
When you copy a selection in Microsoft Word 2000 that contains hidden text, and then paste the selection in a Microsoft Excel 2000 worksheet, the hidden text becomes visible. In contrast, if you paste the selection in Word, the text retains its hidden formatting property.



CAUSE
This behavior occurs because Excel does not support hidden text the way Word does. When you copy a selection containing hidden text in Word, it preserves the hidden formatting. That is, when you paste the selection in Word, it retains the hidden property. Because it does not know whether you want to keep the hidden text or not, Excel retains the text, but drops the hidden formatting property.



WORKAROUND
To work around this problem, after you paste the selection, delete the text you do not want.

Additional query words: XL2000

Keywords: kbinterop kbprb kbpending KB228868

-

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

© Microsoft Corporation. All rights reserved.