Hyperlink to a spcific worksheet

  • Thread starter Thread starter Flipper
  • Start date Start date
F

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


Gary''s Student said:
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


Flipper said:
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
Click to expand...
Click to expand...
 
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

Gary''s Student said:
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


Flipper said:
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
Click to expand...
Click to expand...
Click to expand...
 
that is in the formula as well. It still doesn't work with that in there
though.
--
Allan


Dave Peterson said:
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

Gary''s Student said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Dave Peterson said:
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
Click to expand...
Click to expand...
Click to expand...
 
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


Dave Peterson said:
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

Dave Peterson said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top