Excel - Find and Replace Hyperlink paths
Posted on 2012-08-21
I've honestly searched for a few hours on the internet within different forums and I could not find a resolution for this that worked for me.
Within Excel I have cell's that have hyperlinks to another location on the network and those locations hardcoded in the hyperlink are changing. So instead of manually changing 800 hyperlinks. Anyone have a way to find the beginning portion of a path in the hyperlink and adjust it?
A cell in excel has a name of "Bookkeeping" which is a hyperlink to \\servername1\scans\username\Bookkeeping.xls
That path \\servername1\scans\username... is no longer valid. The new path is \\servername1\department\accounting\bookkeeping.xls
How can i swap
also when i hover over the cell it shows the path. Will this display be corrected once the paths are swapped?
Thanks for your help and time in advance.