Paste Link from Excel Uses Relative Cell References

ID: Q105691

The information in this article applies to:

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.

REFERENCES

"Microsoft Word User's Guide," version 6.0, Chapter 28, "Link to Another File," and Chapter 13, "Working with Tables, Performing Calculations in a Table"

KBCategory: KBSubCategory: Additional query words: 6.0 ole object linking embedding winword word6 word6

Keywords          : kbinterop kbole
Version           : 6.0
Platform          : WINDOWS

Last Reviewed: February 6, 1998