error in hyperlink

[desparate]

I tried to use =hyperlink formula within a nested if formula, I can see the
link underline btu when I click on the link, it show "cannot open specific
file".

The link is to same file, different worksheet.

Please help

 

[Dave Peterson]

What is your exact formula?

I'd create the =hyperlink() formula with other file open, then close the file.

(Yep. I'm betting a typo in your formula.)

But this kind of thing works ok for me:
=HYPERLINK("C:\my documents\excel\book1.xls#'sheet 1'!A1")

It goes to A1 of 'Sheet 1' of that workbook.

 

[desparate]

Hi Dave,

I had solve the problem using
"http://www.microsoft.com/office/com...5298&catlist=&dglist=&ptlist=&exp=&sloc=en-us"

Thank you for your help.

Cheers.