Hyperlink to a spcific worksheet

[Flipper]

I am having trouble inserting a hyperlink that will go to a specific
worksheet in another workbook. The link below does open the workbook, but it
won't go to the sheet I want, which in this instance is "1991C".

=HYPERLINK("[w://Courtney/Recon/LnRec-8-09.xls]1991C", "Click to see
September 2009 Reconciliation")

Can anyone offer a solution?

Thanks

 

[Gary''s Student]

This will open a file, open a specific sheet, and go to a specific cell:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

 

[Flipper]

I copied your verbiage exactly as it appears below and replaced your file
locations and names with mine. It still opens the workbook but now states
"Reference is not valid". Here is my formula:

file:///W:\Courtney\Recon\LnRec-8-09.xls#1991C!a1

Even if I omit the "file///", it still returns the same error message.



--
Allan

This will open a file, open a specific sheet, and go to a specific cell:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

--
Gary''s Student - gsnu200905

I am having trouble inserting a hyperlink that will go to a specific
worksheet in another workbook. The link below does open the workbook, but it
won't go to the sheet I want, which in this instance is "1991C".

=HYPERLINK("[w://Courtney/Recon/LnRec-8-09.xls]1991C", "Click to see
September 2009 Reconciliation")

Can anyone offer a solution?

Thanks

 

[Dave Peterson]

What happened to the =hyperlink() function?

I copied your verbiage exactly as it appears below and replaced your file
locations and names with mine. It still opens the workbook but now states
"Reference is not valid". Here is my formula:

file:///W:\Courtney\Recon\LnRec-8-09.xls#1991C!a1

Even if I omit the "file///", it still returns the same error message.

--
Allan

This will open a file, open a specific sheet, and go to a specific cell:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

--
Gary''s Student - gsnu200905

I am having trouble inserting a hyperlink that will go to a specific
worksheet in another workbook. The link below does open the workbook, but it
won't go to the sheet I want, which in this instance is "1991C".

=HYPERLINK("[w://Courtney/Recon/LnRec-8-09.xls]1991C", "Click to see
September 2009 Reconciliation")

Can anyone offer a solution?

Thanks

 

[Flipper]

that is in the formula as well. It still doesn't work with that in there
though.
--
Allan

What happened to the =hyperlink() function?

I copied your verbiage exactly as it appears below and replaced your file
locations and names with mine. It still opens the workbook but now states
"Reference is not valid". Here is my formula:

file:///W:\Courtney\Recon\LnRec-8-09.xls#1991C!a1

Even if I omit the "file///", it still returns the same error message.

--
Allan

This will open a file, open a specific sheet, and go to a specific cell:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

--
Gary''s Student - gsnu200905


:

I am having trouble inserting a hyperlink that will go to a specific
worksheet in another workbook. The link below does open the workbook, but it
won't go to the sheet I want, which in this instance is "1991C".

=HYPERLINK("[w://Courtney/Recon/LnRec-8-09.xls]1991C", "Click to see
September 2009 Reconciliation")

Can anyone offer a solution?

Thanks

 

[Dave Peterson]

If you have a hyperlink that you added to the worksheet via Insert|Hyperlink (or
ctrl-k), then remove it.

Then try reentering the =hyperlink() formula once more.

If that doesn't work, share what went wrong and share the complete formula.

that is in the formula as well. It still doesn't work with that in there
though.
--
Allan

What happened to the =hyperlink() function?

I copied your verbiage exactly as it appears below and replaced your file
locations and names with mine. It still opens the workbook but now states
"Reference is not valid". Here is my formula:

file:///W:\Courtney\Recon\LnRec-8-09.xls#1991C!a1

Even if I omit the "file///", it still returns the same error message.

--
Allan

:

This will open a file, open a specific sheet, and go to a specific cell:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

--
Gary''s Student - gsnu200905


:

I am having trouble inserting a hyperlink that will go to a specific
worksheet in another workbook. The link below does open the workbook, but it
won't go to the sheet I want, which in this instance is "1991C".

=HYPERLINK("[w://Courtney/Recon/LnRec-8-09.xls]1991C", "Click to see
September 2009 Reconciliation")

Can anyone offer a solution?

Thanks

 

[Flipper]

For whatever reason, the formula now works. I must haved typed it
incorrectly, although I reviewed it very carefully.

Anyway, thank you very much.
--
Allan

If you have a hyperlink that you added to the worksheet via Insert|Hyperlink (or
ctrl-k), then remove it.

Then try reentering the =hyperlink() formula once more.

If that doesn't work, share what went wrong and share the complete formula.

that is in the formula as well. It still doesn't work with that in there
though.
--
Allan

What happened to the =hyperlink() function?



Flipper wrote:

I copied your verbiage exactly as it appears below and replaced your file
locations and names with mine. It still opens the workbook but now states
"Reference is not valid". Here is my formula:

file:///W:\Courtney\Recon\LnRec-8-09.xls#1991C!a1

Even if I omit the "file///", it still returns the same error message.

--
Allan

:

This will open a file, open a specific sheet, and go to a specific cell:

=HYPERLINK("file:///C:\Documents and
Settings\User\Desktop\Book2.xls#Sheet2!B9")

--
Gary''s Student - gsnu200905


:

I am having trouble inserting a hyperlink that will go to a specific
worksheet in another workbook. The link below does open the workbook, but it
won't go to the sheet I want, which in this instance is "1991C".

=HYPERLINK("[w://Courtney/Recon/LnRec-8-09.xls]1991C", "Click to see
September 2009 Reconciliation")

Can anyone offer a solution?

Thanks