Knowledge Base

WD98: Excel Object Range Name Changes Format After Paste Link

Article ID: 197834

Article Last Modified on 10/4/2002

APPLIES TO

This article was previously published under Q197834

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 at the beginning of this article.

Additional query words: row column format

Keywords: kbbug kbpending KB197834


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.