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