We have a workbook that has many worksheets. Each worksheet has many hyperlinks pointing to files on our network drive.
The problem is the hyperlinks all point to the exact path:
\\server1\excel\books\*.*
Is there a way to edit all the hyperlinks in the workbook and doing a find/replace like...