When double clicking on link in cell it doesn't go the cell.
 

I have links between worksheets in one particular workbook. Usually if you
double click on the link, you get linked to that particular cell. However,
when I double click it only shows the formula in the cell instead of linking
to the cell. How do I fix my worksheet to allow my to link when I double
click? Thanks.

When double clicking on link in cell it doesn't go the cell.
 

Tools|Options|Edit tab
uncheck edit directly in cell.

Brian wrote:

I have links between worksheets in one particular workbook. Usually if you
double click on the link, you get linked to that particular cell. However,
when I double click it only shows the formula in the cell instead of linking
to the cell. How do I fix my worksheet to allow my to link when I double
click? Thanks.

--

Dave Peterson