Changing all the links to an Excel spreadsheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top