I use Excel and Word a lot. I find the paste special function very useful to take a cell from Excel and have it pasted into Word. That way I can change the numbers once in Excel and when I open the Word document it asks me if I want to update the linked cells. However, if I insert a row or a column on the spreadsheet the links to Word do not also change and I end up having to re-do the paste special with the new cell.
Is there any way to insert a column or row in Excel and have the linked cells in Word to change/follow to the new cell so I don't have to redo the paste special?
Thank you!
Bookmarks