Ps. I've never seen anything like this, but there have a few posts that said
this sometimes helps.

Dave Peterson wrote:

I don't really have a guess, but if you start a new workbook and try this, does
it suffer from the same problem?

If not, how about trying this against the troublesome workbook.

Ctrl-a (twice in xl2003) to select all the cells
edit|replace
what: = (equal sign)
with: = (equal sign)
replace all

Maybe this will wake up excel's calculation engine by forcing it to reevaluate
all your formulas.

(maybe not, though...)

He4Giv wrote:

Hello
I have a simple sum formula in Cell A2 that adds two cells "=sum(A1:b1)" for
example. For some reason when I change the numbers or add numbers to Cell A1
or B1 the result of the formula dosent change in Cell A2 unless I page down
and page up and then It shows the new total. Ive used formulas for years and
every time I made a change to a number you could see the result in the cell
containing the Sum formula right away even though I was in the same frame of
that worksheet. My Auto calculate is checked vs using manual calculation
under ToolsOptions. Im using Office 2000.
What causes this?
--
He4Giv (Dick)

--

Dave Peterson

--

Dave Peterson