Virus?? Cells not summing??

  • Thread starter Thread starter MEI
  • Start date Start date
M

MEI

Having a very strange problem on several workstations. Cells are not summing
correctly. Let's say cell A4 is a sum of cells A1..A3 It will properly sum
the cells the first time but if I go back and change the contents of Cells
A1..A3 the new sum will not update? Very strange...
 
I suspect you turned of calculation, either intentionally or
with a macro or addin that terminated.
Tools, Options, Calculation, automatic

If the problem persists you should be aware that it is the
first workbook that is opened that controls this, and that
is usually your personal.xls So you would close out of
all of your workbooks, unhide your personal.xls, fix the
calculation, and hide your personal.xls again.

If the problem still persists you will have to identify what
is changing it and the best way I know of is to find out as
soon as possible that it has been changed to manual.
So you could use a macro when starting up Excel to
warn you if the calculation has been changed to manual
and to set it to automatic.
http://www.mvps.org/dmcritchie/excel/slowresp.htm#addins
code is for the Auto_open in your current workbook not your
personal.xls
 
Hi

Set calculation back to automatic in the Tools > Options menu.

HTH. Best wishes Harald
 
It sounds to me as if calculation is set to Manual

Try Tools > Options > Calculation and make sure that Automatic is selected

HTH

Sandy
 
Hi,

Check to see that Calculation is not set to Manual on those workstations.
Tool/Options/Calculation

Paul
 
Back
Top