So we are doing a very large SharePoint migration.  We are moving our sites from 2003 to 2007.  Our finance team does all their work in excel and in these excel files they have links that point to a variety of other excel documents. 

The problem that we ran into is that our old sites (2003) existed on one server and the new sites (2007) are on a completely different server.  We are trying to figure out an easy solution that doesn’t involve us having to manually go though each excel document and change the link so that it points to the correct file on the new server.

We hope that someone else has run into this problem and figure out an easy way to automate the process.

Thanks for the help,

Kevin