Tools>Options>Edit.
Uncheck "edit directly in cell".
Now when you double-click on a linked cell, you will switch to the source
worksheet.
Won't go back to original linked cell.
It's a one-way street.
Alternative..........
In an unused cell enter a hyperlink to the linked sheet.
Gord Dibben Excel MVP
