I've had that problem before and have no idea why hyperlinks become inactive
after awhile. I'm afraid the only thing I can suggest is to select each
hyperlink, press F2 and then enter. This will restore each hyperlink. You
could record a macro to do it. Possibly one of the MVP's could help with
looping VBA code to automate the process. HTH
--
Sincerely, Michael Colvin
"TheRanz" wrote:
I am using a Excel Spreadsheet to track news releases. Within the
spreadsheet I have hyerlinks that I can click on to go to a web site and
review any new press releases. Today none of my hyperlinks work and I am
getting the error message "cannot download the information you requested".
Can anyone give me a hint on if there is a fix for this? I have more than
400 links that are not working.
|