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!
Bookmarks