T
Travis
I have a Word document which is linked to an Excel spreadsheet. The
Word document has numerous words, sentences, charts and tables which
change every time the spreadsheet is changed. The linked cells and
ranges are all named in Excel, so it points to named cells rather than
cell references.
My question is, how do I change all the links at once?
The linked spreadsheet is located at c:/path1/spreadsheet.xls
I'd like to change all the links to c:/path2/spreadsheet.xls without
changing anything else.
So where previously the link was c:/path1/spreadsheet.xls/cell1 I now
want c:/path2/spreadsheet.xls/cell1
And I want to do all of these changes at once, for hundreds of links.
Is that possible?
Travis
Word document has numerous words, sentences, charts and tables which
change every time the spreadsheet is changed. The linked cells and
ranges are all named in Excel, so it points to named cells rather than
cell references.
My question is, how do I change all the links at once?
The linked spreadsheet is located at c:/path1/spreadsheet.xls
I'd like to change all the links to c:/path2/spreadsheet.xls without
changing anything else.
So where previously the link was c:/path1/spreadsheet.xls/cell1 I now
want c:/path2/spreadsheet.xls/cell1
And I want to do all of these changes at once, for hundreds of links.
Is that possible?
Travis