Yes, that is correct. It's a swine, isn't it?

As one of the other posters has said, linking to external workbooks
can be very problematic.

Pete

On Dec 18, 5:33*pm, jane wrote:
Hi Pete,
Sorry about the re-post - I thought I needed to to properly direct my
question to the right experts. Didn't realize you could see across categories
- now I know :)

your suggestion.... each individual would need to do that for each of
their own files within those folders, correct?



"Pete_UK" wrote:
Just because you have posted here, this won't get you a more pleasing
answer than the ones you have elsewhere.

However, one thing you can do is to use Find & Replace (CTRL-H) to
change the path(s) to suit the new arrangement after you have moved
the folders.

Hope this helps.

Pete

On Dec 18, 3:34 pm, jane wrote:
We are planning a re-configuration of our primary Drive and will be moving
most of our folders and subfolders. *We commonly use hyperlinks between
workbooks. *We are an Excel dependent department nad have thousands of files
within our primary folders and subfolders.

During testing, I find that when the source workbook is moved, the hyperlink
to that workbook no longer works and I get: *"Cannot open specified file."

I need to move the folders and subfolders soon and need to know how to
prevent this error from occurring when the users try to use the hyperlinks.

Also, vlookups - I know my vlookups to sheets within a workbook will be
fine. *Will the vllokups to other workbooks break also?

THANK YOU IN ADVANCE!! *jane

.- Hide quoted text -

- Show quoted text -