Spreadsheet with hundred hyperlinks that need to change
I have a spreadsheet that has a hundred or so links (as hyperlinks) to pdf
files on a server share. The original links were pointing to
\\ServerA\share\file.pdf
The new location is \\ServerB\Share\file.pdf However I have to do this to a
hundred links! Is there a way to bulk change this. A find and replace doesn't
seem to work.
Thanks,
TKE402
|