software

i am getting an error when trying to hyperlink from one page in a workbook to
another page in the same workbook. the error simply states that quot;cannot open
the specified filequot;
is there a way to fix this???

At a guess I would say that you have omitted the # from the sheetname
if it is in the same workbook, and so the formula is trying to open a
file with the name of the worksheet you are trying to jump to.

Can you post your formula here and we'll be able to comment more
accurately?

PeteShare what you used for the hyperlink and how you created it (Insert|Hyperlink
or =hyperlink()).

Karenatallied wrote:
gt;
gt; i am getting an error when trying to hyperlink from one page in a workbook to
gt; another page in the same workbook. the error simply states that quot;cannot open
gt; the specified filequot;
gt; is there a way to fix this???

--

Dave Peterson

Hi Guys,

the scenario is as follows:

i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
are in the same workbook named quot;New Yorkquot;.

I used the HYPERLINK function shown below:
=HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)

and also tried manually editing the formula as follows:
=HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)

where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
workbook containing both sheets is named quot;New Yorkquot;

I get the same error message in both situations.

any insight would be appreciated...

Thanks
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)

Karenatallied wrote:
gt;
gt; Hi Guys,
gt;
gt; the scenario is as follows:
gt;
gt; i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
gt; named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
gt; Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
gt; are in the same workbook named quot;New Yorkquot;.
gt;
gt; I used the HYPERLINK function shown below:
gt; =HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)
gt;
gt; and also tried manually editing the formula as follows:
gt; =HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)
gt;
gt; where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
gt; cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
gt; workbook containing both sheets is named quot;New Yorkquot;
gt;
gt; I get the same error message in both situations.
gt;
gt; any insight would be appreciated...
gt;
gt; Thanks

--

Dave Peterson

I've been trying to work these suggestions into my formula but i'm not sure
if i am understanding what each argument means to enter it properly.

=HYPERLINK - i understand is the formula

(quot;#quot;amp;CELL - does this represent something else other than what it
is... meaning
do i type this in as is or am i supposed to replace
it with an actual cell
reference?

(quot;addressquot;,sheetone!C5), - i took this to mean the actual path to the
worksheet and
cell i'm trying to link to.. whe
(quot;addressquot;, - means the workbook the sheets are located in

sheetone!C5), - means the sheet name and cell reference
perhaps this is where my mistake is?

sheetone!C5) - being the text in the linked to worksheet/cell being used
as a name
for the hyperlink

so this what i came up with.... but i get a #VALUE! error

=HYPERLINK(quot;#quot;amp;CELL(quot;New Yorkquot;,'YTD Income-Summary -
Cons'!A1),quot;Consolidatedquot;)

where quot;New Yorkquot; is the workbook both sheets are in
where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
where !A1 is the cell i would like to link to
where quot;Consolidatedquot; is the name i would like to name the link on the link
from
worksheet

can you tell what it is i'm doing wrong?

thanks.

quot;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; Karenatallied wrote:
gt; gt;
gt; gt; Hi Guys,
gt; gt;
gt; gt; the scenario is as follows:
gt; gt;
gt; gt; i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
gt; gt; named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
gt; gt; Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
gt; gt; are in the same workbook named quot;New Yorkquot;.
gt; gt;
gt; gt; I used the HYPERLINK function shown below:
gt; gt; =HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)
gt; gt;
gt; gt; and also tried manually editing the formula as follows:
gt; gt; =HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)
gt; gt;
gt; gt; where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
gt; gt; cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
gt; gt; workbook containing both sheets is named quot;New Yorkquot;
gt; gt;
gt; gt; I get the same error message in both situations.
gt; gt;
gt; gt; any insight would be appreciated...
gt; gt;
gt; gt; Thanks
gt;
gt; --
gt;
gt; Dave Peterson
gt;

=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'YTD Income Summary - ANY'!A1),quot;ClickMequot;)

should go to A1 of 'YTD Income Summary - ANY'

(And you said that this is all internal to the workbook--so that name isn't
important.)
Karenatallied wrote:
gt;
gt; I've been trying to work these suggestions into my formula but i'm not sure
gt; if i am understanding what each argument means to enter it properly.
gt;
gt; =HYPERLINK - i understand is the formula
gt;
gt; (quot;#quot;amp;CELL - does this represent something else other than what it
gt; is... meaning
gt; do i type this in as is or am i supposed to replace
gt; it with an actual cell
gt; reference?
gt;
gt; (quot;addressquot;,sheetone!C5), - i took this to mean the actual path to the
gt; worksheet and
gt; cell i'm trying to link to.. whe
gt; (quot;addressquot;, - means the workbook the sheets are located in
gt;
gt; sheetone!C5), - means the sheet name and cell reference
gt; perhaps this is where my mistake is?
gt;
gt; sheetone!C5) - being the text in the linked to worksheet/cell being used
gt; as a name
gt; for the hyperlink
gt;
gt; so this what i came up with.... but i get a #VALUE! error
gt;
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;New Yorkquot;,'YTD Income-Summary -
gt; Cons'!A1),quot;Consolidatedquot;)
gt;
gt; where quot;New Yorkquot; is the workbook both sheets are in
gt; where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
gt; where !A1 is the cell i would like to link to
gt; where quot;Consolidatedquot; is the name i would like to name the link on the link
gt; from
gt; worksheet
gt;
gt; can you tell what it is i'm doing wrong?
gt;
gt; thanks.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; David McRitchie posted this and it might help you:
gt; gt;
gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)
gt; gt;
gt; gt; Karenatallied wrote:
gt; gt; gt;
gt; gt; gt; Hi Guys,
gt; gt; gt;
gt; gt; gt; the scenario is as follows:
gt; gt; gt;
gt; gt; gt; i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
gt; gt; gt; named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
gt; gt; gt; Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
gt; gt; gt; are in the same workbook named quot;New Yorkquot;.
gt; gt; gt;
gt; gt; gt; I used the HYPERLINK function shown below:
gt; gt; gt; =HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)
gt; gt; gt;
gt; gt; gt; and also tried manually editing the formula as follows:
gt; gt; gt; =HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)
gt; gt; gt;
gt; gt; gt; where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
gt; gt; gt; cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
gt; gt; gt; workbook containing both sheets is named quot;New Yorkquot;
gt; gt; gt;
gt; gt; gt; I get the same error message in both situations.
gt; gt; gt;
gt; gt; gt; any insight would be appreciated...
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

i copied and pasted your formula below into my worksheet and now when i hit
enter to accept it, it opens a quot;openquot; dialog box. if i click on the folders
to find the workbook again, it causes excel to shut down. just a note, i am
running F9 on this machine, would that interfere at all with this???quot;Dave Petersonquot; wrote:

gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'YTD Income Summary - ANY'!A1),quot;ClickMequot;)
gt;
gt; should go to A1 of 'YTD Income Summary - ANY'
gt;
gt; (And you said that this is all internal to the workbook--so that name isn't
gt; important.)
gt;
gt;
gt;
gt; Karenatallied wrote:
gt; gt;
gt; gt; I've been trying to work these suggestions into my formula but i'm not sure
gt; gt; if i am understanding what each argument means to enter it properly.
gt; gt;
gt; gt; =HYPERLINK - i understand is the formula
gt; gt;
gt; gt; (quot;#quot;amp;CELL - does this represent something else other than what it
gt; gt; is... meaning
gt; gt; do i type this in as is or am i supposed to replace
gt; gt; it with an actual cell
gt; gt; reference?
gt; gt;
gt; gt; (quot;addressquot;,sheetone!C5), - i took this to mean the actual path to the
gt; gt; worksheet and
gt; gt; cell i'm trying to link to.. whe
gt; gt; (quot;addressquot;, - means the workbook the sheets are located in
gt; gt;
gt; gt; sheetone!C5), - means the sheet name and cell reference
gt; gt; perhaps this is where my mistake is?
gt; gt;
gt; gt; sheetone!C5) - being the text in the linked to worksheet/cell being used
gt; gt; as a name
gt; gt; for the hyperlink
gt; gt;
gt; gt; so this what i came up with.... but i get a #VALUE! error
gt; gt;
gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;New Yorkquot;,'YTD Income-Summary -
gt; gt; Cons'!A1),quot;Consolidatedquot;)
gt; gt;
gt; gt; where quot;New Yorkquot; is the workbook both sheets are in
gt; gt; where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
gt; gt; where !A1 is the cell i would like to link to
gt; gt; where quot;Consolidatedquot; is the name i would like to name the link on the link
gt; gt; from
gt; gt; worksheet
gt; gt;
gt; gt; can you tell what it is i'm doing wrong?
gt; gt;
gt; gt; thanks.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; David McRitchie posted this and it might help you:
gt; gt; gt;
gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)
gt; gt; gt;
gt; gt; gt; Karenatallied wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Hi Guys,
gt; gt; gt; gt;
gt; gt; gt; gt; the scenario is as follows:
gt; gt; gt; gt;
gt; gt; gt; gt; i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
gt; gt; gt; gt; named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
gt; gt; gt; gt; Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
gt; gt; gt; gt; are in the same workbook named quot;New Yorkquot;.
gt; gt; gt; gt;
gt; gt; gt; gt; I used the HYPERLINK function shown below:
gt; gt; gt; gt; =HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)
gt; gt; gt; gt;
gt; gt; gt; gt; and also tried manually editing the formula as follows:
gt; gt; gt; gt; =HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)
gt; gt; gt; gt;
gt; gt; gt; gt; where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
gt; gt; gt; gt; cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
gt; gt; gt; gt; workbook containing both sheets is named quot;New Yorkquot;
gt; gt; gt; gt;
gt; gt; gt; gt; I get the same error message in both situations.
gt; gt; gt; gt;
gt; gt; gt; gt; any insight would be appreciated...
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I have no idea what F9 is.

Try changing (temporarily) the name of worksheet quot;ytd income summary - anyquot; to A
(just a single letter).

Then use this:
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,a!A1),quot;ClickMequot;)

Then rename the sheet to what you want.

There's a difference between what you wrote in your message and what that
worksheet is called in real life.

Karenatallied wrote:
gt;
gt; i copied and pasted your formula below into my worksheet and now when i hit
gt; enter to accept it, it opens a quot;openquot; dialog box. if i click on the folders
gt; to find the workbook again, it causes excel to shut down. just a note, i am
gt; running F9 on this machine, would that interfere at all with this???
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'YTD Income Summary - ANY'!A1),quot;ClickMequot;)
gt; gt;
gt; gt; should go to A1 of 'YTD Income Summary - ANY'
gt; gt;
gt; gt; (And you said that this is all internal to the workbook--so that name isn't
gt; gt; important.)
gt; gt;
gt; gt;
gt; gt;
gt; gt; Karenatallied wrote:
gt; gt; gt;
gt; gt; gt; I've been trying to work these suggestions into my formula but i'm not sure
gt; gt; gt; if i am understanding what each argument means to enter it properly.
gt; gt; gt;
gt; gt; gt; =HYPERLINK - i understand is the formula
gt; gt; gt;
gt; gt; gt; (quot;#quot;amp;CELL - does this represent something else other than what it
gt; gt; gt; is... meaning
gt; gt; gt; do i type this in as is or am i supposed to replace
gt; gt; gt; it with an actual cell
gt; gt; gt; reference?
gt; gt; gt;
gt; gt; gt; (quot;addressquot;,sheetone!C5), - i took this to mean the actual path to the
gt; gt; gt; worksheet and
gt; gt; gt; cell i'm trying to link to.. whe
gt; gt; gt; (quot;addressquot;, - means the workbook the sheets are located in
gt; gt; gt;
gt; gt; gt; sheetone!C5), - means the sheet name and cell reference
gt; gt; gt; perhaps this is where my mistake is?
gt; gt; gt;
gt; gt; gt; sheetone!C5) - being the text in the linked to worksheet/cell being used
gt; gt; gt; as a name
gt; gt; gt; for the hyperlink
gt; gt; gt;
gt; gt; gt; so this what i came up with.... but i get a #VALUE! error
gt; gt; gt;
gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;New Yorkquot;,'YTD Income-Summary -
gt; gt; gt; Cons'!A1),quot;Consolidatedquot;)
gt; gt; gt;
gt; gt; gt; where quot;New Yorkquot; is the workbook both sheets are in
gt; gt; gt; where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
gt; gt; gt; where !A1 is the cell i would like to link to
gt; gt; gt; where quot;Consolidatedquot; is the name i would like to name the link on the link
gt; gt; gt; from
gt; gt; gt; worksheet
gt; gt; gt;
gt; gt; gt; can you tell what it is i'm doing wrong?
gt; gt; gt;
gt; gt; gt; thanks.
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; David McRitchie posted this and it might help you:
gt; gt; gt; gt;
gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)
gt; gt; gt; gt;
gt; gt; gt; gt; Karenatallied wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi Guys,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; the scenario is as follows:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
gt; gt; gt; gt; gt; named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
gt; gt; gt; gt; gt; Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
gt; gt; gt; gt; gt; are in the same workbook named quot;New Yorkquot;.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I used the HYPERLINK function shown below:
gt; gt; gt; gt; gt; =HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; and also tried manually editing the formula as follows:
gt; gt; gt; gt; gt; =HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
gt; gt; gt; gt; gt; cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
gt; gt; gt; gt; gt; workbook containing both sheets is named quot;New Yorkquot;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I get the same error message in both situations.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; any insight would be appreciated...
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

I did as you suggested and voila, it worked. i was able to rename the
worksheet back to it's original name and it still works. thanks so much for
your time and help in getting this to work for me!!! i truly appreciate it.

btw, F9 is a program that works to import our accounting software
information (GL balances and such) into excel worksheets to be calculated and
further manipulated.

quot;Dave Petersonquot; wrote:

gt; I have no idea what F9 is.
gt;
gt; Try changing (temporarily) the name of worksheet quot;ytd income summary - anyquot; to A
gt; (just a single letter).
gt;
gt; Then use this:
gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,a!A1),quot;ClickMequot;)
gt;
gt; Then rename the sheet to what you want.
gt;
gt; There's a difference between what you wrote in your message and what that
gt; worksheet is called in real life.
gt;
gt; Karenatallied wrote:
gt; gt;
gt; gt; i copied and pasted your formula below into my worksheet and now when i hit
gt; gt; enter to accept it, it opens a quot;openquot; dialog box. if i click on the folders
gt; gt; to find the workbook again, it causes excel to shut down. just a note, i am
gt; gt; running F9 on this machine, would that interfere at all with this???
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'YTD Income Summary - ANY'!A1),quot;ClickMequot;)
gt; gt; gt;
gt; gt; gt; should go to A1 of 'YTD Income Summary - ANY'
gt; gt; gt;
gt; gt; gt; (And you said that this is all internal to the workbook--so that name isn't
gt; gt; gt; important.)
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Karenatallied wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; I've been trying to work these suggestions into my formula but i'm not sure
gt; gt; gt; gt; if i am understanding what each argument means to enter it properly.
gt; gt; gt; gt;
gt; gt; gt; gt; =HYPERLINK - i understand is the formula
gt; gt; gt; gt;
gt; gt; gt; gt; (quot;#quot;amp;CELL - does this represent something else other than what it
gt; gt; gt; gt; is... meaning
gt; gt; gt; gt; do i type this in as is or am i supposed to replace
gt; gt; gt; gt; it with an actual cell
gt; gt; gt; gt; reference?
gt; gt; gt; gt;
gt; gt; gt; gt; (quot;addressquot;,sheetone!C5), - i took this to mean the actual path to the
gt; gt; gt; gt; worksheet and
gt; gt; gt; gt; cell i'm trying to link to.. whe
gt; gt; gt; gt; (quot;addressquot;, - means the workbook the sheets are located in
gt; gt; gt; gt;
gt; gt; gt; gt; sheetone!C5), - means the sheet name and cell reference
gt; gt; gt; gt; perhaps this is where my mistake is?
gt; gt; gt; gt;
gt; gt; gt; gt; sheetone!C5) - being the text in the linked to worksheet/cell being used
gt; gt; gt; gt; as a name
gt; gt; gt; gt; for the hyperlink
gt; gt; gt; gt;
gt; gt; gt; gt; so this what i came up with.... but i get a #VALUE! error
gt; gt; gt; gt;
gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;New Yorkquot;,'YTD Income-Summary -
gt; gt; gt; gt; Cons'!A1),quot;Consolidatedquot;)
gt; gt; gt; gt;
gt; gt; gt; gt; where quot;New Yorkquot; is the workbook both sheets are in
gt; gt; gt; gt; where 'YTD Income-Summary - Cons' is the worksheet i would like to link to
gt; gt; gt; gt; where !A1 is the cell i would like to link to
gt; gt; gt; gt; where quot;Consolidatedquot; is the name i would like to name the link on the link
gt; gt; gt; gt; from
gt; gt; gt; gt; worksheet
gt; gt; gt; gt;
gt; gt; gt; gt; can you tell what it is i'm doing wrong?
gt; gt; gt; gt;
gt; gt; gt; gt; thanks.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; David McRitchie posted this and it might help you:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
gt; gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
gt; gt; gt; gt; gt; =HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Karenatallied wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Hi Guys,
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; the scenario is as follows:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; i am trying to link from a quot;Table of Contentsquot; sheet to cell quot;A1quot; in a sheet
gt; gt; gt; gt; gt; gt; named quot;YTD Income Summary - ANYquot; and naming the link cell quot;New York Onlyquot;.
gt; gt; gt; gt; gt; gt; Both the quot;Table of Contentsquot; sheet and the quot;YTD Income Summary - ANYquot; sheet
gt; gt; gt; gt; gt; gt; are in the same workbook named quot;New Yorkquot;.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I used the HYPERLINK function shown below:
gt; gt; gt; gt; gt; gt; =HYPERLINK('YTD Income-Summary - ANY'!A1,quot;New York Onlyquot;)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; and also tried manually editing the formula as follows:
gt; gt; gt; gt; gt; gt; =HYPERLINK(quot;[new york]'YTD Income-Summary - Cons'!A1quot;,quot;Consolidatedquot;)
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; where the sheet being linked to is quot;YTD Income-Summary - Consquot;, the link
gt; gt; gt; gt; gt; gt; cell is named quot;Consolidatedquot; on the quot;Table of Contentsquot; sheet and the
gt; gt; gt; gt; gt; gt; workbook containing both sheets is named quot;New Yorkquot;
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I get the same error message in both situations.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; any insight would be appreciated...
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thanks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;