I have about 300 rows of data in an excel 2007 document that contain a hyperlink to another location. The location (server) changed names and is somewhat a more complex name.
Is there a quick solution for changing the location without editing each of the 300 rows? The foldername is not changing.
Prior to the change - the Hyperlink showed:
The location has changed to:
Any help provided would be appreciated.