Link in the same w/s is pulling a different number.

[Guest]

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]

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

Tools|options|calculation tab

 

[Guest]

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

 

[Dave Peterson]

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

 

[Guest]

Yes... that simple.

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

 

[Dave Peterson]

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????

Yes... that simple.