Hyperlink problem

[bestmom]

I'm having a real problem and I'd appreciate some help please

I have one worksheet called Customer Database. In one cell I have a hyperlink that I cannot get to work. It reads
=HYPERLINK("[c:\Documents and Settings\All Users\Shared Documents\Marina\Service Database.xls]AllenA","Allen"
In another worksheet called Service Database, I have a range named Allen

I am trying to get it so that when I click on the word "Allen" in the first worksheet, the second worksheet opens u
with the cursor at the start of the range named "AllenA

This will be the same for each customer, so there will be a few hundred hyperlinks in the first worksheet, all o
which open up the second sheet, but each time in a different position dependant upon the range name

According to the info in the help screens I have all my brackets and such in the right place, but when I click o
Allen (which is underlined and in blue) I get the error message cannot open the specified file. I have so far spen
4 hours trying to figure this out and I just cannot see where I am going wrong. Please help!! And I'm not an expert,
so I would appreciate a simple answer - idiot proof!!

 

[DDM]

Bestmom, this worked for me (Excel 2003):

=HYPERLINK("C:\Documents and Settings\DDM\Desktop\My Employee
List.xls!Smith","Smith")

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I'm having a real problem and I'd appreciate some help please.

I have one worksheet called Customer Database. In one cell I have a

hyperlink that I cannot get to work. It reads:

=HYPERLINK("[c:\Documents and Settings\All Users\Shared

Documents\Marina\Service Database.xls]AllenA","Allen")

In another worksheet called Service Database, I have a range named AllenA

I am trying to get it so that when I click on the word "Allen" in the

first worksheet, the second worksheet opens up

with the cursor at the start of the range named "AllenA"

This will be the same for each customer, so there will be a few hundred

hyperlinks in the first worksheet, all of

which open up the second sheet, but each time in a different position dependant upon the range name.

According to the info in the help screens I have all my brackets and such

in the right place, but when I click on

Allen (which is underlined and in blue) I get the error message cannot

open the specified file. I have so far spent

4 hours trying to figure this out and I just cannot see where I am going

wrong. Please help!! And I'm not an expert,

 

[bestmom]

Thanks for your help, but it doesn't work for me! Tried putting the exclamation mark in and taking out the square brackets and various combinations there of, but still nothing works

Anybody have any other suggestions please?

 

[Frank Kabel]

Hi
try
=HYPERLINK("c:\Documents and Settings\All Users\Shared
Documents\Marina\Service Database.xls#Service Database!AllenA","Allen")

 

[bestmom]

Thanks Frank, but that didn't work either. This is just so frustrating, it must be something really stupid that I've got wrong, but I just can't figure it

Anyone else able to offer a suggestion please?

 

[Peo Sjoblom]

You can insert a hyperlink without using a formula under insert>hyperlink,
then just look up the file and select it, now you can either use this
instead
and give it name under Text to display or copy the address from address box,
wrap it in quotes and put it in the formula. I noticed that you are using
All Users in your path, are you sure the file is in the shared documents,
maybe it should be your name instead? Regardless, you can use the
insert>hyperlink
as well or at least get the exact address from there

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Thanks Frank, but that didn't work either. This is just so frustrating, it

must be something really stupid that I've got wrong, but I just can't figure
it.