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.

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.

Michael, thanks for the info. I tried the F2 and enter and it still does not
work. I believe the issue is related to my computer as the links work on
another the computer. So it appears to me as I have a problem with Excel on
my computer. It my be that I have to reinstall Office to resolve the issue.

"Michael" wrote:

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.