Googling this question turned up a lot of people with the *opposite* problem, so
I'm convinced I must be overlooking something obvious. The issue arises on 2
different PCs, running Excel 2000 and 2003, both with WinXP.

I have several hundred files to be hyperlinked from a spreadsheet. When done
they're all destined for a CD. So I figure we need all the hyperlink paths to
be relative, that is, the address field for each link should be in the form
\mystuff.txt and not E:\mystuff.txt (nor any other letter plus :\mystuff.txt)..

But no matter what I put in the 'Hyperlink Base' box in File-> Properties->
Summary, when I pick a cell in the sheet, click Insert-> Hyperlink, and BROWSE
to a file to be linked, that file's full ABSOLUTE path gets inserted.

Is there a way to disable that? I see tons of posts saying you can *type* the
file's relative path, but oddly enough, nobody mentions how convenient it would
be if you could make the Browse button automatically INSERT said relative path.
This is why I'm convinced something obvious has escaped me. Is there no way
to make it do that?

I know I can de-absolute all the links at once afterward with a little macro
that cycles through them & applies the VBA Replace function, but that seems like
sort of a back-assward way to "fix" it. Am I crazy? (Shhhhh!)

If the answer is bonehead simple, I promise to slink quietly back into my cave.

TIA!!

Mark Tangard
"Life is nothing if you're not obsessed." --John Waters