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

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

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

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

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

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