Microsoft KB Archive/105691

{|
 * width="100%"|

Paste Link from Excel Uses Relative Cell References

 * }

Q105691

-

The information in this article applies to:


 * Microsoft Word for Windows, version 6.0

-

SYMPTOMS
When you paste link an Microsoft Excel worksheet into a Word for Windows document, the field code in Word contains R1C1 notation references (such as R1C1 or R3C2) rather than A1 notation references (such as A1 or C2) regardless of what notation the worksheet is using. By default Excel worksheets use A1 notation.

For example, if you copy cell A1 in an Excel worksheet and paste link it in a Word document, the field code references the cell as "R1C1".

CAUSE
Word performs the paste link operation using the R1C1 notation reference that Excel copies to the Windows Clipboard. Note: By contrast, when you perform calculations in a Word table, Word references cells using A1 cell references.