How do I link worksheet data in a Word file and have the links be.

  • Thread starter Business Archictect
  • Start date
B

Business Archictect

I have inserted a "Word" object icon into a worksheet and then used paste
link features to display data updates in the Excel file in the Word document
that is in the worksheet. I am looking for a way to have the links from the
Excel file into the inserted Word file in that Excel file automatically
update and be independent of the Excel filename.

Problem is I put the Word document icon into the Excel file, open it, paste
link data from the Excel file and then when I rename the Excel file the links
are not automatically reflecting the new Excel name. Right now there are
"invalid link" references being displayed.

I would appreciate anyone's assistance to find a workable solution so that I
don't have to have users trying to manually changing file links everytime
they rename their baseline Excel file.

Thanks, David
 
Top