We are planning a re-organize 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 and have hundreds of files
within our primary folders and subfolders.

During testing, I find that when the source workbook is moved, the hyperlink
in the dependent 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 vlookups to other workbooks break also?

THANK YOU IN ADVANCE!! jane

All of your links will break if you move your files or folders and there is
nothing you can do about it other than to fix all of the files after the
move. When I say all I mean ALL. Formulas, hyperlinks and anything else that
refers to external workbooks. That is the main pitfall of linking workbooks
and the reason that I personally (almost) never do it.
--
HTH...

Jim Thomlinson


"jane" wrote:

We are planning a re-organize 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 and have hundreds of files
within our primary folders and subfolders.

During testing, I find that when the source workbook is moved, the hyperlink
in the dependent 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 vlookups to other workbooks break also?

THANK YOU IN ADVANCE!! jane

If you don't care to count the week - as a week - where the start & end date
are "lying", - then you have got an answer.
If you do care - please response
Micky


"jane" wrote:

We are planning a re-organize 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 and have hundreds of files
within our primary folders and subfolders.

During testing, I find that when the source workbook is moved, the hyperlink
in the dependent 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 vlookups to other workbooks break also?

THANK YOU IN ADVANCE!! jane