Locking a Cell linked to Word Document

garebear

New Member
Joined
Feb 18, 2011
Messages
1
I have several cells that are linked to a word document and they work great as long as I don't add row or columns or change the original location of the cell. Is there a way that I can add a row or a column in the excel worksheet without throwing off all my linked cells? Eg. I have cell D129 linked to my word document. That cell has a number useful in the same word document. However when I add a row lower in the excel sheet it moves everything down including the data in cell d129. So now the data that was in D128 is now D129 and D129 is now D130 etc. The data now in the current D129 is not the data I want in word. Is there a way to attach the link to D129 and if the cell moves to have the link "follow it"?

Respectfully
Gary
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Forum statistics

Threads
1,214,925
Messages
6,122,303
Members
449,078
Latest member
nonnakkong

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top