Microsoft KB Archive/105691: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
| Line 24: | Line 24: | ||
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.<br /> | 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.<br /> | ||
<br /> | <br /> | ||
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 | 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". | ||
<br /> | <br /> | ||
| Line 38: | Line 38: | ||
== 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" | |||
Additional query words: 6.0 ole object linking embedding winword word6 | Additional query words: 6.0 ole object linking embedding winword word6 | ||
Latest revision as of 09:58, 20 July 2020
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.
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"
Additional query words: 6.0 ole object linking embedding winword word6
Keywords : kbinterop kbole
Issue type :
Technology :
Last Reviewed: November 4, 2000 |
