Knowledge Base

WD97: Excel Object Range Name Changes Format After Paste Link

Article ID: 195481

Article Last Modified on 1/23/2007

APPLIES TO

This article was previously published under Q195481

SYMPTOMS

When you paste link a Microsoft Excel object into a Word document, the range name changes to a cell reference (CxRx) format.

CAUSE

This problem occurs when you select the range in Excel and use the Copy Picture command (hold SHIFT and then on the Edit menu, click Copy Picture).

WORKAROUND

To work around this problem, use the Copy command instead of the Copy Picture command in Excel.

NOTE: The disadvantage to using this method is that an embedded chart is not copied as part of the link. An embedded chart is available only when you use the Copy Picture command.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed above.

Additional query words: row column format

Keywords: kbbug kbfaq kbpending KB195481


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.