Paste Link from Excel Uses Relative Cell References

 Last reviewed: February 6, 1998
Article ID: 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.

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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 6, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.