hyperlinks - absolute path refuses to stay!!!!

[neowok]

i have a whole bunch of hyperlinks to various files and folders that i
need kept absolute because sometimes users will copy my workbook to a
disk and run it off the disk, meaning any relative paths will not
work.

so after looking around ive basically concluded the only way to enter
an absolute path into a hyperlink in excel is to manually go and look
at the entire directory structure, and then manually type in the exact,
absolute path (which is a long path!).

The problem is i just did that, went off to look at a coupe of other
things, come back and the link which *DID* work now no longer works and
the bluddy thing has inserted loads of ..\..\..\..\ where i typed in
the absolute path!!!!!

This is absolutely rediculous, there appears to be no way what so ever
to 1: get the absolute path used in the first place, and 2: KEEPING the
goddamn hyperlink using the SAME bluddy path that you just had to go
and type in manually.

I know you can set a 'hyperlink base address' for all hyperlinks in the
workbook. This is useless because i have some hyperlinks to webpages,
and a load of hyperlinks to files in various folders on this network
drive.

i must be missing something because nobody would be stupid enough to
have designed it like this, not EVEN MS.

 

[jammy]

erm which version of excel are you using?

cause just a quick peek at excel97 shows you can do Insert ->
Hyperlink, browse to the file/location you want (or type it in if you
know), then theres a little checkbox for relative path or absolute.

 

[neowok]

im using excel 2002 SP2. theres no checkboxes at all on the ad
hyperlink window

 

[neowok]

i guess nobody knows whats going on with this then

 

[Guest]

I saw your post when looking for a solution to the same problem. Here's what I found...

Hi Michael,

I'm also one Sharepoint administrator with the same type of problem.

Try to update the configuration of your Office:
- Open any Office tool (Word, Excel, Powerpoint)
- Click Tools and Options...
- Open the General tab and Web Options...
- Open the Files tab and uncheck Update links on save

Bruno