Hi All

I can Hyperlink to files outside my work book, by using insert hyperlink but
I cannot link to a worksheet within my book no matter how I try to do it. I
am using excel 2003 and Vista. Is there anything else I should be doing.

THIS IS THE FORMULA I USE TO HYPERLINK TO FILES OUTSIDE MY WORK BOOk
=HYPERLINK(LEFT(CELL("Filename",A1),SEARCH("[",CELL("filename",A1))-25))&"Driver C package\Drivers C spreadsheet.xls"

The work book is called The road accounting Program

THE WORK SHEET I AM TRYING TO ACCESS IS CALLED

Road Cash Accounting