Just when I think I've got this stuff figured out... WHAM!! I ge
kicked in the *&@# and left gasping for air.

My *wonderful* spreadsheet (which is going to drive me to drink) ha
some hyperlinks; some pointing to various network drives, some pointin
to other sheets within the workbook.

I originally left the hyperlink base blank, but found out that when
moved the XLS to another location, all my links became "relative".

So, to fix the problem, I set the Hyperlink Base to a network drive.
Seemed to work just fine until I clicked on a link to another shee
within the workbook. Now THOSE don't work.


Is there anyway to have the best of both worlds??!?


Thanks in advance to whoever can help me!!

PS: I'm an Excel newbie, so please, be gentle.


~ Matt

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