Forum Discussion
Excel Formula Calculations Reverting to Manual After I Change to Automatic
The setting in the Excel options is already set to Automatic. It's the workbook calculation that keeps changing intermittently.
Like if you change the workbook to Automatic from the Forumula's tab, save the document, then open it.. it's still Automatic... but if you wait a while, then open the same workbook.. it's reverted back to Manual, even when the option is set in the Excel options itself.
Settings in File->Options and on ribbon are synced, that doesn't matter where to change.
One of possible reasons if you have some workbook in Automatic opened and after that open another workbook with Manual, first workbook also will shift to Automatic.
Another reason could be in VBA, third-party add-ins or templates if you use them.
Perhaps something else, not sure right now.
- Same problem. It does have a connection to VBA. I have a workbook with a command button that imports and formats data using VBA instructions. Any time that button is clicked, and another workbook with auto calculate selected is open, the auto calculate workbook gets reverted to manual.
