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?

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

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

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

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

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