Is there an easy way to change all of the links in a Word document?
Let's say, I have a linked word document and an excel workbook that I set up as templates to use. I'll be entering data into tables in excel, and those tables are linked to the word document. Each time I start a new project, I'll be using a new word doc and excel book and need to change the name of each to correspond to the new project. The table format/structure in excel will be the same, but the data and file names/locations will change.
Is there an easy way to change the links in word to reflect the new name of the excel file, without having to manually change each link? I'm a relatively advanced (so I think) excel user, but have very limited VB knowledge.
If anyone knows of a way to make this work without resorting to creating macros, I'd appreciate it!
Let's say, I have a linked word document and an excel workbook that I set up as templates to use. I'll be entering data into tables in excel, and those tables are linked to the word document. Each time I start a new project, I'll be using a new word doc and excel book and need to change the name of each to correspond to the new project. The table format/structure in excel will be the same, but the data and file names/locations will change.
Is there an easy way to change the links in word to reflect the new name of the excel file, without having to manually change each link? I'm a relatively advanced (so I think) excel user, but have very limited VB knowledge.
If anyone knows of a way to make this work without resorting to creating macros, I'd appreciate it!
