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

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

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