hyperlink error

  • Thread starter Thread starter Eyde
  • Start date Start date
E

Eyde

I have a spreadsheet that has over 1000 hyperlink pdf files in it that are on
our shared network and all I have to do is to select the cell that contains
the pdf that is needed and the pdf comes up. Everything has been great until
this morning when we had a power failure and I was in working on the
spreadsheet, after recovery of the spreadsheet now all the hyperlinks are
going to my c: drive. How can I get back the right path without having to go
into each hyperlink and doing an edit. I sure hope someone can help me if not
it will take day's to redo all the hyperlinks.
 
Thanks so much I have used Macros in AutoCAD many times but did not even
think about using them in Excel.

Eyde
 
Back
Top