Calculations not updating

[Nomas]

Hi,

I am using excel 2007. I have a sheet that i paste data into and normally it updates. It currently is not however. I have automatic calculations selected (it says calculate at the bottom). All I can think is that this time I was extending the data set by filling down and at a certain point it stopped calculation and just started filling the same number down regardless of the value. Now when I put new data in, it doesn't update at all. Not sure where to go. Any guidance is appreciated.

Thanks,

 

[GlennUK]

If Excel says Calculate at the bottom it does not signify that calculations are automatic. Before going any further, go into your settings and check what the calculation mode is.

 

[Nomas]

Hi Glenn,

Under Formulas, Calculations, Calulation Options its set to Automatic. If I should look somewhere else let me know. I would be happy to check.

 

[Biz]

If workbook updates when you press F9 then your workbook is on Manual calculation mode.

One way to test this
1)Press ALT +11
2) CTRL + G which invokes Immediate Window
3)Paste code below

?application.Calculation=xlCalculationAutomatic

If you get False then manual calculation. If True then autocals.

Biz

 

[GlennUK]

Have a read of this and see if it helps:

http://www.decisionmodels.com/calcsecretsc.htm

 

[Nomas]

Glenn/Biz,

Thank you both so much for the help. Good info to know. I appreciate it! Sorry for the delayed response.