Computed value does not appear...

[G.G. Biggar, Jr.]

I am on a Windows 2000 platform, using Office 2000. Recently, when I enter
data in a cell, which is linked to other cells on the spreadsheet, the newly
computed values in the other cells do not appear until I hit Save, or until
I enter data elsewhere on the spreadsheet. The only software changes to my
system have been two security updates from the Windows Update web site.

Does anyone have any thoughts why the changed values are delayed in
appearing on my screen?

Thanks in advance.

Gordon Biggar
Houston, Texas

 

[Gord Dibben]

Gordon

Tools>Options>Calculation

Change to "automatic"

Gord Dibben Excel MVP

 

[G.G. Biggar, Jr.]

Sir Dibben --

I had hunted through the Tool bar, looking for a solution. Obviously, I
looked in all of the wrong places. When I did a check on the myriad of
other Excel files stored on my system, the Automatic box was (obviously)
checked.

I guess I won't attempt to assess how this one got turned off. Many thanks.

Gordon Biggar

 

[Gord Dibben]

Gordon

Excel takes the Calculation mode each session from the settings on the first
workbook opened in that session.

i.e. If you saved Book1 with calc mode in manual and opened it first, calc
mode would be in Manual.

If you saved Book2 with calc mode in auto and opened it after Book1, Book2
would be in manual mode(Excel ignores the auto calc mode in this case).

If you close Book1 before opening Book2, Book2 will be in auto calc mode.

Confusing enough? <g>

Gord