View Single Post
  #1   Report Post  
leoe
 
Posts: n/a
Default find and replace path name in Excel cells containing hyperlink

Does anyone know of a way to do a "find and replace" of Excel cells
containing hyperlinks? The standard find and replace does not seem to examine
the hyperlink file.
I'll be getting Excell spreadsheets containing hundreds of cells containing
hyperlinks to to a project's local drive and I will be moving them to a
network drive and want to change the "path" of the linked file to a specific
SharePoint website folder.
Any ideas? Can you put me in contact with a Excel expert