software

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 quot;cannot open specific
filequot;.

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(quot;C:\my documents\excel\book1.xls#'sheet 1'!A1quot;)

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

desparate wrote:
gt;
gt; I tried to use =hyperlink formula within a nested if formula, I can see the
gt; link underline btu when I click on the link, it show quot;cannot open specific
gt; filequot;.
gt;
gt; The link is to same file, different worksheet.
gt;
gt; Please help

--

Dave Peterson

Hi Dave,

I had solve the problem using
quot;www.microsoft.com/office/community/en-us/default.mspx?query=hyperlink erroramp;dg=microsoft.pu blic.excel.worksheet.functionsamp;cat=en-us-excelamp;lang=enamp;cr=USamp;pt=f3f7ac8a-4ea0-4c36-bed9-8feae6d75298amp;catlist=amp;dglist=amp;ptlist=amp;exp=amp;sloc=en-usquot;

Thank you for your help.

Cheers.

quot;Dave Petersonquot; wrote:

gt; What is your exact formula?
gt;
gt; I'd create the =hyperlink() formula with other file open, then close the file.
gt;
gt; (Yep. I'm betting a typo in your formula.)
gt;
gt; But this kind of thing works ok for me:
gt; =HYPERLINK(quot;C:\my documents\excel\book1.xls#'sheet 1'!A1quot;)
gt;
gt; It goes to A1 of 'Sheet 1' of that workbook.
gt;
gt; desparate wrote:
gt; gt;
gt; gt; I tried to use =hyperlink formula within a nested if formula, I can see the
gt; gt; link underline btu when I click on the link, it show quot;cannot open specific
gt; gt; filequot;.
gt; gt;
gt; gt; The link is to same file, different worksheet.
gt; gt;
gt; gt; Please help
gt;
gt; --
gt;
gt; Dave Peterson
gt;