close

I am trying to hyperlink to a different worksheet in the same workbook using
the hyperlink and cell functions. Here is the formula:

=HYPERLINK(CELL(quot;filenamequot;,GMT96X_PMC_PDU_ReWork!A 10 ),quot;RWquot;)

When clicking on the hyperlink a window pops up quot;Cannot open the specified
file.quot; I believe the issue is with the path that is created with filename
and the other worksheet / cell reference, but I do not see it.

All help is appreceiated.
--
rst

David McRitchie posted this and it might help you:

=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)so...

=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'GMT96X_PMC_PDU_ReWo rk'!A10),quot;RWquot;)

If I didn't screw up the copy|pasting.trimm54 wrote:
gt;
gt; I am trying to hyperlink to a different worksheet in the same workbook using
gt; the hyperlink and cell functions. Here is the formula:
gt;
gt; =HYPERLINK(CELL(quot;filenamequot;,GMT96X_PMC_PDU_ReWork!A 10 ),quot;RWquot;)
gt;
gt; When clicking on the hyperlink a window pops up quot;Cannot open the specified
gt; file.quot; I believe the issue is with the path that is created with filename
gt; and the other worksheet / cell reference, but I do not see it.
gt;
gt; All help is appreceiated.
gt; --
gt; rst

--

Dave Peterson

GREAT!. That worked. Thanks.
--
rstquot;Dave Petersonquot; wrote:

gt; David McRitchie posted this and it might help you:
gt;
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)
gt;
gt;
gt; so...
gt;
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'GMT96X_PMC_PDU_ReWo rk'!A10),quot;RWquot;)
gt;
gt; If I didn't screw up the copy|pasting.
gt;
gt;
gt; trimm54 wrote:
gt; gt;
gt; gt; I am trying to hyperlink to a different worksheet in the same workbook using
gt; gt; the hyperlink and cell functions. Here is the formula:
gt; gt;
gt; gt; =HYPERLINK(CELL(quot;filenamequot;,GMT96X_PMC_PDU_ReWork!A 10 ),quot;RWquot;)
gt; gt;
gt; gt; When clicking on the hyperlink a window pops up quot;Cannot open the specified
gt; gt; file.quot; I believe the issue is with the path that is created with filename
gt; gt; and the other worksheet / cell reference, but I do not see it.
gt; gt;
gt; gt; All help is appreceiated.
gt; gt; --
gt; gt; rst
gt;
gt; --
gt;
gt; Dave Peterson
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()