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