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.
Application.Calculation = xlCalculationAutomatic