Hyperlink not working

R

rodolform

I'm working with Excel 2002 and what to make a hyperlink into anothe
xls file using the hyperlink function, I use this string:
("[C:\Documents and Settings\Al
Users\Documents\november.xls]daily",("daily file"))

where november.xls is the file I want to open and daily is the specifi
worsheet, daily file is what apears on the hyperlink, when I hit th
Hyperlin it does open the november file but does not take me to th
daily worksheet and opens a "Reference is not valid" sign, I have mak
sure that the daily Ws exists and have tried with other WS in the sam
file with the same results.

I have tried with the insert function but is worst because th
hypelinks does not work at all.

Thanks in advance.
Rodolf
 
J

JR

Rodolfo,

It appears that you need to define a cell - name it
anything you wish - on your target spreadsheet. Say
you name cell A1 "Target", then your link line would read
=hyperlink("[C:\Documents and Settings\All
Users\Documents\november.xls]Target",("daily file"))
It should take you there with no error message.
(I could not get the link to use the worksheet name alone
at all, either.)
jlr
 
D

David McRitchie

You are missing the exclamation point

=HYPERLINK("[h:\excel2k\testng2k.xls]sheet3!a1","SHEET3")
=HYPERLINK("[c:\temp folder\xyz abc.xls]'Sheet One'!$C$5","Sheet One")

for something closer to what you need see
Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink

try something like the following:
=hyperlink("[C:\Documents and Settings\All Users\Documents\November.xls]daily!A1", "daily file")
 
Top