find and replace path name in Excel cells containing hyperlink

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace within a hyperlink 8
Find and replace a value within a formula 2
Replace hyperlink throughout excel 5
Change hyperlink throughout excel 1
Find/Replace within links in cells 1
How to find and Replace hyperlink in hold sheet? 1
hyperlinks within Excel 3
Find and Replace Hyperlink Contents 11

Top