Question about hyperlink behavior...

[BVHis]

Okay... here's the deal.

I've got a spreadsheet with hyperlinks that are created whenever a use
presses a button and selects a file.

If I save the spreadsheet, close it, move it to another network drive
the links are NOT found. It links are now looking to a relative pat
rather than the actual path. Is this normal Excel Hyperlink behavio
and if so, how can I make it act like I want it to??

In other words, if my links are pointing to the T:\ drive and then
move the spreadsheet to the R:\ drive, the spreadsheet is no longe
look at T:\ but rather R:\. This is really starting to get on m
nerves. What a way to start the week.


Please help!!

Thanks in advance!

~ Matt W :confused

 

[Tom Ogilvy]

For this problem,
Dick Kusleika suggested using Hyperlink Base under File=> Properties. He
said then all hyperlinks are relative to the base.

He did say the hyperlinks are relative and that can't be changed - but the
above seems to be the solution.


http://groups.google.com/groups?selm=#[email protected]