Knowledge Base

WD2000: Excel Object Range Name Changes Format After Paste

Article ID: 197838

Article Last Modified on 12/6/2000

APPLIES TO

This article was previously published under Q197838

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 of 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 kbnofix kbfaq KB197838


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.