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;
- Apr 21 Sat 2007 20:37
Hyperlink using filename
close
全站熱搜
留言列表
發表留言