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