Documents move is generating link errors in Excel
 

I have searched the net high and low for an answer to this and have not found
any. Maybe I'm just not asking the search engines the right questions so I
thought I'd ask the experts.

We are moving user's documents to a new server. For most this has not been
an issue. We've moved 95% of the company and no problems. But suddenly we
find a fellow that has an excel workbook which contains links to other excel
workbooks.

Once his documents were moved, when he opened a workbook containing links to
other workbooks he recieved an error. Now, that was easily enough fixed by
redirecting the link at the prompt. And since he only had 9 such workbook it
was not a problem to do manually.

But, and we are talking a badonkadonk but here, I am slowly working my way
to 2 users who have upwards of 80-100 workbooks, many of them with external
links. As much as I'd like to tell them they are out of lick and will hae to
fix them all manually after the move, that is not really business friendly.

So, any suggestions? Should these have updated when the move occured and it
was just a quirk that those few didn't and I shouldn't worry?

From what I have read, there is a built in tool that would allow you to
change all the similar links on a page but that is still one book/one sheet
at a time, one external book/sheet at a time.

I have read a little about VB scripts and I'm thinking that may work better
but I do not know VB so if someone could point me to a solid script for that
which either works or only needs minor adjustments I think I could manage.
But then again you all may know a better, quicker way.

Ideally we just need to change the \\servername at the beginning of all the
links as that is the only part of the path that will changed.

Thanks for your time.