Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 Hyperlink error
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel 2007 Hyperlink error
Resolved · Medium Priority · Version 2007
Reply Wed 17 Nov 2010, 13:32Delegate Suzi said...
Suzi has attended:
Excel Advanced course
Word Intermediate course
Excel 2007 Hyperlink error
I have created Hyperlinks from an Excel 2007 spreadsheet to Word and PDF files in other drives on a shared network. The links work initially. When the file is saved (also on the network) however, the link no longer works.
The address used for the link has changed from L:\Certified Fisheries\Cornish sardine to
..\..\Fisheries\Certified%20Fisheries\Cornish%20sardine
The error message reads: The address of this site is not valid. Check the address and try again.
I found some solutions on the internet to similar problems which involved changing the hyperlink base (File|Properties|Summary Tab|Hyperlink Base). I can't figure out how to do this in Excel 2007 and therefore can't tell if it will work.
Any ideas?
For upcoming training course dates see: Pricing & availability
RE: Excel 2007 Hyperlink error
Hi Suzi, thanks for your query. You change the hyperlink base in Excel 2007 by clicking 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.
Hope this helps,
Anthony
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
|