Double Clicking on link w/i workbook does't bring me to souce.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When in excel and linking a cell on tab one to say tab 3 within the workbook
I have previously been able to double click on the item and the program jumps
me to the source cell. Currenlty what happens is that the curser just
remains in the cell and awaits edits - perhaps it circle highlights the
source cell. At my new place of employment this does not happen & all other
individuals state they have never heard of this capability. I am sure it
exists and that something needs to be activiated not not sure what - can
anyone help?
 
tfranc,

Tools / Options.... "Edit" tab, UNCheck "Edit directly in cell"

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

double click on cell that have link, Excel will jump to the refere 1
I can not create an external link between two Excel 2007 workbooks 1
Why can I not link my workbooks in excel 2
double click through to link 2
double clicking on a source cell 1
Linking workbooks together 1
Excel should allow clicking on a linked cell to jump to source 9
Paste Links not updating automatically. 1

Back
Top