Hi,
I have tried placing a hyperlink in a cell on sheet1 workbook1 to sheet1 of workbook 2 however it opens the workbook but does not take me to the correct worksheet stating: Reference is not valid.
Link is Abstractions.xls#Master for example
Can you please advise.
Thank you
Last edited by jpruffle; 04-03-2009 at 04:57 AM.
try adding a cell reference
Abstractions.xls#master!A1
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you I tried that but again it comes up with invalid reference.
mine works fine. what version of excel are you using
Excel 2000!
insert /hyperlink
click existing file or web page
use browse for file to find other work book
once found click bookmarks and select sheet.
Excellent it worked great thanks for all your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks