trouble shoot pointing to a cell
 

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?

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

On Tue, 13 Sep 2005 10:29:04 -0700, "Tracy"
wrote:

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?

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

"Gord Dibben" wrote:

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

On Tue, 13 Sep 2005 10:29:04 -0700, "Tracy"
wrote:

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?