Excel hyperlink folder problem

[Barry]

I have Excel 2002 and I am having a hyperlinking problem. I have set
up Excel so that when I click on the "client name" in a cell, the
hyperlink opens the folder that contains all of the documents
associated with that client.

The folders for the individual clients are located several folders
down on our business server. When I created the hyperlink and tested
it originally, I found the correct folder in Explorer and cut and
pasted it into the Excel Hyperlink tool. I then tested it and found
out that it worked correctly.

When I came back the next day and began to try to use the function and
I clicked on the hyperlink, I was taken to a folder that is 3 folders
above the individual "client name" folder. When I took a look at the
actual hyperlink using the edit command, I can see that the entire
path is correctly listed, but for some reason Excel will not take me
the rest of the way down into the folders.

As I examine the path more closely I have noticed something funny. At
the exact point where Excel stops going down in the path, the former
backslashes have been changed to forward slashes by Excel. Note
between "DOCUMENTATION - Supt,App,Client" and "/CLIENT DELIVERABALES,
DOCS"

Here is how it was originally listed:
groups\IT\Private\Client Delivery\IT Groups\DP&CPU\DOCUMENTATION -
Supt,App,Client\CLIENT DELIVERABALES, DOCS\Southern Hospital 43432

Here is how Excel changed the path:
groups\IT\Private\Client Delivery\IT Groups\DP&CPU\DOCUMENTATION -
Supt,App,Client/CLIENT DELIVERABALES, DOCS/Southern Hospital 43432

Can anyone tell me why this is happening? And more importantly, how
can I fix it so that this does not continue to happen.

Thanks for the help

Barry

 

[Dave Peterson]

Until you get a better response...

I use the =hyperlink() worksheet function and have had no trouble with this kind
of thing.

 

[Barry]

I am still looking for the answer to my problem. I have researched
and found other people who have posted the same problem but have never
found an answer to the problem

Thanks,

Barry

 

[Dave Peterson]

How about testing something?

If you're using xl2002+ (I don't think this option is in xl2k or lower)
and if you're links change when you save (or close/save and reopen).

tools|options|general tab|click on the Web Options button
Files Tab
Uncheck "update links on save"

===

 

[Barry]

Dave,

That seemed to work. I have to see now if it works the same way for
everyone else using the program as well. There are several of us that
share the use of this Excel workbook. I would assume that I need to
get everyone to update the same way.

Thanks,

Barry

 

[Dave Peterson]

This looks like a combination workbook/application setting to me (kind of like
calculation mode).

I opened two workbooks and toggled this setting in one. When I went to the
other workbook to inspect the setting, it had changed.

I toggled it the other way, went back to the original and it was changed!

I think this might be a battle for the control of your soul.

If you miss one person, you might have more trouble later.

You may find it easier adding an auto_open routine:

option explicit
sub auto_open()
With Application.DefaultWebOptions
' .SaveHiddenData = True
' .LoadPictures = True
.UpdateLinksOnSave = False
' .CheckIfOfficeIsHTMLEditor = True
' .AlwaysSaveInDefaultEncoding = False
' .SaveNewWebPagesAsWebArchives = False
End With
end with

(or even workbook_beforesave????)