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.

On 08/18/2011 09:49, Terry Pinnell wrote:
Dave wrote:

Saved from a previous post:

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

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

In xl2007:
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.

Thanks Dave, appreciate the help.

I've just tried the above but unfortunately it didn't work. I changed the
base to C:\

Then, with a clean cell, I browsed to
C:\Docs\My Videos\Intro MPGs\Zakopane2002.mpg

The Hyperlink dialog box filename was now
Docs\My Videos\Intro MPGs\Zakopane2002.mpg
which looks correct.

But opening it still gives the error "An unexpected error has occurred."

And all OTHER previously working links now fail, with the message "The
address of this site is not valid. Check the address and try again." I
thought that simply clearing the base again would fix that, but it hasn't
;-(

I'll take a deep breath and a coffee and then tackle it further!


--
Dave Peterson