When you are forced to migrate documents to another location, as we are forced now to do so by Dropbox, all the hyperlinks will be unfunctional. I've 1000 docs and around 50.000 internal and external hyperlinks which will be affected. So, a huge problem!
In Word with alt+F9 you can find and replace all the hyperlinks* in a document at once.
* the complete link or only the portion that need to be changed and is the same in all these hyperlinks.
In Excel this does not work. After many hours of searching I did not find a solution. I posted the question to the Microsoft Community, but got no answer yet.
How can we do this in Excel?
Thanks,
Guido
