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" <Tracy@discussions.microsoft.com>
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" <Tracy@discussions.microsoft.com>
> 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?
>
>