error in hyperlink
 

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

error in hyperlink
 

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 wrote:

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

error in hyperlink
 

Hi Dave,

I had solve the problem using
"http://www.microsoft.com/office/community/en-us/default.mspx?query=hyperlink+error&dg=microsoft.pu blic.excel.worksheet.functions&cat=en-us-excel&lang=en&cr=US&pt=f3f7ac8a-4ea0-4c36-bed9-8feae6d75298&catlist=&dglist=&ptlist=&exp=&sloc=en-us"

Thank you for your help.

Cheers.

"Dave Peterson" wrote:

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 wrote:

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