This worked to open book2.xls and go to A1 of sheet1:
=HYPERLINK("file:////c:/my documents/excel/book2.xls#sheet1!a1","click me")

cmceng14 wrote:

I am trying to create a hyperlink from one excel file (so you just have to
click on it) and it will open up the referenced excel file, but more
specifically will open the file to the certain sheet you want it to open to.

Is this possible, and if so what is the code or shortcut to get this to work?

Thanks,

--

Dave Peterson