asked on
How to stop Calculation options switching to Manual - for no apparent reason!
I have a spreadsheet - which is constantly defaulting back to Manual Calculation - which is irritating to say the least. I got it from someone else so not sure if they had turned off Automatic Calculation. I checked my own options and they are fine - how do I make sure it doesn't keep going back to Manual.
Microsoft Access
Last Comment
Anders Ebro (Microsoft MVP)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
What would be the best way to deactivate it? Save it as an xlsx?
Yes, you could save it without macros(vba). I can't say however whether the macros are crucial to the operation of the file. There could be custom functions as well, that are needed by the worksheet.
You could also search the code for any place that says xlCalculationManual and try to comment out those lines.
You could also search the code for any place that says xlCalculationManual and try to comment out those lines.
ASKER
Well it was a spreadsheet I got from someone and I didn't know there was macros in it until today! Will follow your advice. Thank you.
ASKER
Yep, you were completely correct. Was VBA in the macro code turning off the automatic calculation feature. Thank you
ASKER
So great to have an expert immediately spot and diagnose what had been bothering me for hours!
Your welcome.
I've been in your shoes a couple of years ago :=)
I've been in your shoes a couple of years ago :=)
End With
Application.ScreenUpdating
Application.Calculation = xlCalculationAutomatic
End Sub