Automatic Calculations

[Berend Botje]

Hi,

For some reason the calculations made in my Excel documents require
manual action, instead of being executed automatically.

I have tried switching to automatic, but it switches back each time
restart Excel.

Is this a known problem or can I fix this

 

[Andy B]

Hi

The status of the calculation mode is set by the first sheet you open in
each session.

 

[Mark]

How many calculations are taking place within your
spreadsheet? There is a limit after which automatic
calcualtions won't work. If you have a huge amount of data
with formulas this may be the reason.

 

[David McRitchie]

Possibly you have not saved Excel.
Possibly you have a bad macro that correctly turned off
screen updating and calculation for the macro but forgot
or terminated before turning them back on.
Calculation will remain turned off.
Possibly you have a bad addin.
(same problems as macro, except usually written by more
experienced people)
Possibly Excel but very doubtful.

Calculation is going to be set by the first workbook that
is brought up by Excel, which would probably be your
personal.xls workbook. So would suggest closing
all your other open workbooks, unhide your personal.xls
workbook, and change the calculation and save your
personal.xls workbook then hide it again. Close Excel.
Reopen Excel.

When I have problems like that -- I have a macro check things
that they are set to my preference.
http://www.mvps.org/dmcritchie/excel/slowresp.htm#addins