ongoing hyperlink problem

[stew]

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 BOO
=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

 

[Gary''s Student]

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")

 

[stew]

Dear " Garys Student"

Thank you Its been a while

Best

Stew

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

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]

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

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