Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Hyperlinks in Excel 2007 dont work from DVD


  • Please log in to reply

#1
brio

brio

    New Member

  • Member
  • Pip
  • 2 posts
Hyperlinks to a jpg file are inserted successfully in Excel 2007, When activited from workbook residing on C:\ where the jpg is also, Explorer is opened and the picture file is displayed correctly. When I transfer a folder containing the workbook and hyperlinked files to a rewritable DVD and test the hyperlinks from there (F:\) before giving the DVD to someone, Explorer opens showing "Connecting..." and nothing happens, so the picture is never displayed. Checked root and it seems ok. Anyone experienced this or know what is going on? or not going on!! :)
  • 0

Advertisements


#2
dm27

dm27

    Member

  • Member
  • PipPipPip
  • 272 posts
Hello Brio,

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)

Microsoft Source

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.

Best regards,


dm
  • 0

#3
brio

brio

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Thanks dm

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.

brio

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP