I haven't used xl2k in a longgggggggggg time.

But I have seen the hyperlink base technique work many times.

I don't have a guess why you're having trouble.

On 08/19/2011 11:19, Terry Pinnell wrote:
Terry wrote:

Dave wrote:

I'd double check that hyperlink base. I've never seen excel behave that way and
changing the hyperlink base has worked for lots of posters.

And after you changed the hyperlink base, did you change the hyperlinks back to
what they were supposed to be. That was the purpose of the link to David
McRitchie's site.

Thanks Dave, appreciate your sticking with this. I'm taking another hard
look at it.

One aspect that I'm finding hard to grasp (haven't touched this stuff for
ages) is the syntax itself. For example, I enter the full location:
C:\Docs\SUNDRY\CD+DVD\CD-DVD Inserts\Anthony39\Front4.jpg

If I then save the spreadsheet (which, in case it's relevant, is at
C:\Docs\Touch_Pro2 My Documents\MyTP2Misc\DVD-Index.xls)
re-open it, and use Edit Hyperlink again, Excel 2000 now shows it as
..\..\SUNDRY\CD+DVD\CD-DVD Inserts\Anthony39\Front4.jpg

Why is that please?

On this page
http://office.microsoft.com/en-us/ex...005202555.aspx
I read:
"You can override the hyperlink base address by using the full, or
absolute, address for the hyperlink in the Insert Hyperlink dialog box."

So when I entered the full address 'C:\Docs\My
Videos\PROJECTS\Flight-Simon-14Aug2011\20110814FlightSimon-2.mp4'
it seems I was right to expect that to work. Despite the inclusion of a
space (My Videos), the addition of quotes was apparently not only
unnecessary but scrambled the whole thing. And presumably that's
regardless of whether there's a base entered in the Properties or not.

However, I'm coming to the conclusion that all that is irrelevant and that
this is an Excel 2000 limitation. I converted a couple of MP4s to MPGs and
the hyperlinks to those worked. I'd still like to hear from anyone else
with Excel 2000 though, to be 100% sure of this!


--
Dave Peterson