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