Hyperlinks in Excel 2007 dont work from DVD
Posted 20 May 2010 - 02:08 PM
Posted 20 May 2010 - 05:47 PM
Welcome to Geeks to Go!
After doing a bit of digging, it sounds like your using absolute hyperlinks (where the paths are hard coded) vs. relative hyperlinks (where the path is "relative" the document's location)
To ensure the links stay tied to the file on the DVD (or other portable media), change your hyperlink path to include just the file name (and the file type extension). I've tested this on a USB drive: placed my excel file and the .jpg image on it and the link worked fine.
Give it a test, and let me know if you are successful.
Posted 21 May 2010 - 02:05 AM
It looks like the system already presents the path correctly, including when transferred to the portable media. In the Edit Hyperlink window there is a "Look in" box which shows the folder where both files reside. A box showing files held in folder and an "Address" box showing the file name and extension.
I have edited these several ways to try and get around the problem but no luck...Like you wrote I have had just file name and extension as well as specifying the path fully and neither work. Sounds like a bug.
Thanks for trying.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users