I've never seen excel not work correctly with formulas like this (and
calculation set to automatic).

But I've seen posts that complain that this can happen.

You could try this:
Select a cell on that worksheet
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Maybe it'll wake up excel????

Joanna wrote:

Yes... that simple.

"Dave Peterson" wrote:

Is your formula a simple
=sheet2!a1
or is it more complex?


Joanna wrote:

That was the first thing I checked.... and it is on automatic.

"Dave Peterson" wrote:

I'd make sure that I was in autocalculate mode first.

Tools|options|calculation tab



Joanna wrote:

I have an excel worksheet with cells that are linked to a different tab in
the worksheet. The cells are correct... but the number is not. I cannot tie
the number that is pulling to anything. If I press F9... the wrong number
still remains... but if I edit the cell and add a +1... it pulls the correct
number.
Heard of anything like that before?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson