Sum function is not updating

[swan717]

Hi:

I have a spreadsheet that has a sum function that does not update until I save the spreadsheet. Can anyone help me figure out why?

Thanks for your help,
Swan717

 

[xlhelp]

Under Tools, Options, Calculation; the calc is set to manual you need to set it to Automatic

or

You can press F9 anytime to recalculate the workbook.

HTH

Indu I will stop procrastinating tomorrow

 

[DaleWatson123321]

Hi Swan,

Can you first check the setting of the "Calculation Mode".

1) Tools - Options

2) Click the "Calculation" tab

The two settings normally used are either: "Automatic" or "Manual".

If set to "Manual", you have the option of changing it to "Automatic", in which case, this should solve your problem.

In the case of a VERY large workbook, it can be an advantage to set the calculation mode to "manual", as this will speed up gereral worksheet activity.

However, if the worksheet IS set to MANUAL calculation, it implicity becomes NECESSARY to hit the &quot;CALC&quot; key <F9> whenever you want the workbook's formulas updated.

Conversely, if your workbook is on the smaller side, you (and your PC is reasonably fast), you probably don't require the MANUAL setting. You should therefore change it to AUTOMATIC.

Hope this helps.

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca

 

[rmikesmith]

Swan717,

Check Tools/Options then click the Calculation tab. My guess is the Manual calc radio button is selected and the recalc before save checkbox is checked. Click on the Automatic radio button.


HTH,
M. Smith

 

[iGrant]

Looks like a clear consensus to me!