This link open the closed workbook "Book1.xls" at the specified sheet/cell...

=HYPERLINK("[C:\Documents and Settings\Name\My Documents\General\Book1.xls]Sheet2!B5","Click Me")

Note the brackets and the placement of the quote marks.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Karenatallied"

wrote in message
i am trying to link from an open workbook to a page in an unopened workbook.
the hyperlink works if both workbooks are open at the same time, but give N/A
when the hyperlinked to workbook is closed. any way to fix this?