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

--
Message posted from http://www.ExcelForum.com

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...gp13.phx. gbl


--
Regards,
Tom Ogilvy


"BVHis " wrote in message
...
Okay... here's the deal.

I've got a spreadsheet with hyperlinks that are created whenever a user
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 path
rather than the actual path. Is this normal Excel Hyperlink behavior
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 I
move the spreadsheet to the R:\ drive, the spreadsheet is no longer
look at T:\ but rather R:\. This is really starting to get on my
nerves. What a way to start the week.


Please help!!

Thanks in advance!

~ Matt W


---
Message posted from http://www.ExcelForum.com/