View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
tke402 tke402 is offline
external usenet poster
 
Posts: 2
Default 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