trouble shoot pointing to a cell

T

Tracy

I have built a worksheet with multiple tabs. Something has happened to the
workbook that is not allowing me to build formulas by pointing to a cell on
another tab. How do I correct this?
 
G

Gord Dibben

Tracy

"Not allowing" means what?

Error message?

Nothing?

Can't select another sheet?

I assume you are entering an "=" sign in a cell then selecting another sheet
and cell then hitting <ENTER>


Gord Dibben Excel MVP
 
T

Tracy

Gordon,

I have a file with many columns in it of data. There are three tabs. If I
select either = or + and then try to select cells in the next tab with my
mouse to "point" it will not select. I can manually move my mouse to a place
far right of the data and then move manually with the keyboard arrow keys.
This file has columns grouped, but open when I am trying to perform this
function. I don't understand what the restriction is....Any ideas?

Thank you,
Tracy
 
Top