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

A tiny trick. Usually to hyperlink to a different worksheet in the same
workbook we use:

=HYPERLINK("#Sheet3!B9")

but our tabname contains blanks, so we must use some single quotes as well:

=HYPERLINK("#'Road Cash Accounting'!B9")

--
Gary''s Student - gsnu200811


"stew" wrote:

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

Dear " Garys Student"

Thank you Its been a while

Best

Stew

"Gary''s Student" wrote:

A tiny trick. Usually to hyperlink to a different worksheet in the same
workbook we use:

=HYPERLINK("#Sheet3!B9")

but our tabname contains blanks, so we must use some single quotes as well:

=HYPERLINK("#'Road Cash Accounting'!B9")

--
Gary''s Student - gsnu200811


"stew" wrote:

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

You may want to read your previous thread to find an alternative.

stew wrote:

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

--

Dave Peterson