How do I move workbooks w/o having to reset the links?

G

Guest

I would like to make copies of folders containing several workbooks, which
changes the path to the source workbook for the numerous links within. Then,
when updates are offered, there are some links that cannot be updated because
the source cannot be found. It's clear that the path has been changed, but
is there any way to prevent the path from changing?
 
G

Guest

Not sure what you mean by keeping the path from changing. You should be able
to fix the links that are not updating (because the source was moved) by
going into Edit/Links. Then, select the source file that is not updating,
click Change Source, and browse for the correct location of the source file.
 

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

Similar Threads

How to create absolue path link to another workbook (Excel 2003) 1
How to create absolute link to cell in another workbook (Excel 2003) 1
Link to another workbook path issue 1
How do I make several workbooks work together? 2
How do you assign a Workbook Location Path to a cell? 1
Get relative Path: advanced workbook linking. 1
Linking workbooks 4
Open Word 2007 doc with link to Excel 2007 4

Top