Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105691

From BetaArchive Wiki

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
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.