In early versions of Excel, there was no edit directly in cell capability. After
Excel added edit directly in cell and turned it on by default,
[Tools->Options->Edit->"Edit directly in cell"] hardly anyone experiences the
great benefit of not editing directly in cell. (In early versions of Excel,
there was no edit directly in cell capability.) 

Turning off direct edit means a double click on a cell which is a link
immediately takes me to the linked cell, no matter what sheet the linked cell is
on. This lets me immediately navigate from a subtotal cell on my Summary sheet
to the exact cell from which the data came. Further, linking a cell (a date) in
each data sheet back to the date on the Summary sheet means I can very quickly
go back and forth to view and evaluate my data (a stock portfolio Summary sheet
and supporting individual stock data sheets) by merely double clicking linked
subtotals on the Summary sheet and a linked date on various data sheets. I've
been checking Calc since a late version 1, have not moved to Calc because of not
being able to quickly navigate, and am finally writing. 

Navigating sheets by double clicking is wonderfully Fast and Direct.