Ask a new question

Linking data (single cell or row) to Word 2010 uses absolute cell reference

I have an excel spreadsheet where I want to link only a single cell (A10) to a Word 2010 document.
However when a insert a row above A10, it updates Word and shows the data that is in A10, instead of A11.
The same happens if I sort the excel document.

For some reason, Paste link uses absolute cell reference instead of relative cell reference
This only happens if I link a single cell, or several cells in one row. Once I link cells in 2 rows, Excel uses relative cell reference.

How can I get Excel to use relative cell reference when linking one cell?

I copy cell in Excel.
In Word - Clipboard - Paste Special - Paste link - Microsoft Excel Worksheeot Object (or Formatted Text) - OK

I'd be thankful for any suggestions

Answer
Answer
Thanks for your suggestion.

I actually found the solution.
Once I pasted the link as a Microsoft Excel Worksheed Object into Word, in Word I right click on the link - Linked Worksheet Object - Links - I checkmark the option called Locked - OK. T
Locked changes the absolute cell reference in Excel to a relative cell reference.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated March 2, 2022 Views 1,223 Applies to: