ongoing hyperlink problem

  • Thread starter Thread starter stew
  • Start date Start date
S

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
 
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")
 
Dear " Garys Student"

Thank you Its been a while

Best

Stew

Gary''s Student said:
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 said:
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
Click to expand...
Click to expand...
 
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
Click to expand...
 
Back
Top