Calculation Options Keep Re-Setting to Manual in Excel

[Swoootie]

Hi all,

I keep encountering a problem in that my Calculation Options keep re-setting to manual every time I run some VBA code in Excel. The code is excecuted via a click button and is meant to update values on the spreadsheet.

I've tried saving the spreadsheet again with the "automatic" selection ticked and also saved my personal.xlsb again but with no luck. All other Excel sheets are closed and this spreadsheet was in perfectly good condition before this morning.

Would be very appreciative of any help!!

Thanks

 

[BrianMH]

The vba code is likely setting the calculation to manual while it is running. You should detect the calculation setting at the beginning of the code and then on exiting set it back to what it was previously set as.

 

[Swoootie]

Thanks for your response Brian.

Funnily enough nothing could revert the calculation options back to automatic in that particular Excel session. I was able to resolve the issue by "moving" the Excel tab in question to a new location, shutting down the old session and saving/closing/re-opening the moved session.
Thought I'd post this on here in case it helps anyone else.

Thanks