Hyperlinks Changed in Recovered document

[Cindy]

My system crashed and automatically shutdown my open excel
document that included 700 links to pdf documents. When I
open the recovered document and saved it, I later noticed
that all the links are pointing to a different location.
I have since learned not to save the recovered document,
but is there a way to change the hyperlinks to point to
the correct drive without having to do it one at a time?

Thanks for any assistance.
Cindy

 

[David McRitchie]

Hi Cindy,
You would have to go through the hyperlinks collections.
Suggest posting to the excel.links newsgroup or searching
newsgroups with a bit more attention to that group.
Suggest when you post there that you include
what the link should look like, and what it does look like.

Was the file restored to the original location before you opened it.-