We are consolidating some of our files into one common 2009 folder, causing the links in our workbooks to break. I am right now, faced with the grim task of updating them 1 by 1.

Is there a way to update all the hyperlinks on a sheet at once.

I need to insert an extra folder in each hyperlink, without modifying the rest.

For example:

J:\Sales\February 2009\Dashboard Feb.09 would need to become
J:\Sales\2009\February 2009\Dashboard Feb.09

The text displayed in the cell would need to remain unchanged.

Thanks for your help!