I have also had this problem and never saw anything like it before. In my
situation, creating a new file did not prevent the problem. Also, it seems
to respond to Save As or deleting blank columns. Then it magically shows the
new values.

The strange thing is it starts refreshing all cells and then stops. The
base calcs change and some of the vlookups referencing them change. It then
freezes. In some cases, you'll see the same number repeated on each row (the
one it becomes stuck on gets repeated).

Once unstuck the file works fine until you add new content, then it freezes
again and I repeat the steps above.

I assume this is a problem in 2003 and am concerned that any complicated
analysis is unstable due to this problem. Has this been identified? Are
they working on it?

"Dave Peterson" wrote:

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