Hyperlinks that do not survive a Save.

[James]

I followed the instructions provided in Microsoft Excel 2007 Help
(Excel>Excel and the Web>Hyperlinks) for adding 10 hyperlinks to an Excel
worksheet and I can access the source files only until I save the worksheet.

After I save the worksheet and click on the hyperlink, this message appears:
"The address of this site is not valid. Check the address and try again."

I made no changes to the worksheet between the successful access of the file
and the unsuccessful attempt other than saving the worksheet.

I appreciate all ideas for solving this problem.

Thanks!

 

[Shane Devenshire]

Hi,

Try saving the file before you add the hyperlinks.

 

[MattLeson]

Well aware this is an old thread, but it's one of the first results on Google and the issue occurs in Excel 2010. Comes courtesy of Dave Peterson on a different thread I found once. Tested and this resolves the issue.

In Excel 2003 menus:
File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

In Excel 2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.

In Excel 2010:
File -> Info -> Show All Properties
Update Hyperlink Base in the list on the right