|
Hyperlink to a spcific worksheet
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 -- Allan |
Hyperlink to a spcific worksheet
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" wrote: 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 -- Allan |
Hyperlink to a spcific worksheet
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" wrote: 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" wrote: 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 -- Allan |
Hyperlink to a spcific worksheet
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 "Gary''s Student" wrote: 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" wrote: 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 -- Allan -- Dave Peterson |
Hyperlink to a spcific worksheet
that is in the formula as well. It still doesn't work with that in there
though. -- Allan "Dave Peterson" wrote: 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 "Gary''s Student" wrote: 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" wrote: 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 -- Allan -- Dave Peterson |
Hyperlink to a spcific worksheet
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. Flipper wrote: that is in the formula as well. It still doesn't work with that in there though. -- Allan "Dave Peterson" wrote: 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 "Gary''s Student" wrote: 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" wrote: 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 -- Allan -- Dave Peterson -- Dave Peterson |
Hyperlink to a spcific worksheet
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" wrote: 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. Flipper wrote: that is in the formula as well. It still doesn't work with that in there though. -- Allan "Dave Peterson" wrote: 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 "Gary''s Student" wrote: 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" wrote: 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 -- Allan -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 06:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com