I have found a solution that may help others who, like me, could not get the well-documented fixes to work ....
Scenario:
Worksheet shows as 'Calculate' in Status Bar, despite Excel Options being set to Automatic,
Pressing F9 or Calculate does a recalc but 'Calculate' reappears immediately
No background VBAs continually amending Calculation.
No Personal.xlsm or add-ins set to Manual.
Re-saving Worksheet with Calc set to Auto has no effect.
The Cause/Solution:
I had inadvertently created a simple circular reference in the worksheet.
There were no Circ Reference warnings in this case, but when - in desperation - I unchecked 'Enable iterative calculation' in Excel Options/Formulas/Iterations, I suddenly got Circular Ref warnings in the Status Bar.
Clearing the circular refs, and rechecking 'Enable iterative calculation' brought everything back to normal.
So here's hoping this may help someone else puzzled why their worksheet is stuck in 'Manual' !
Scenario:
Worksheet shows as 'Calculate' in Status Bar, despite Excel Options being set to Automatic,
Pressing F9 or Calculate does a recalc but 'Calculate' reappears immediately
No background VBAs continually amending Calculation.
No Personal.xlsm or add-ins set to Manual.
Re-saving Worksheet with Calc set to Auto has no effect.
The Cause/Solution:
I had inadvertently created a simple circular reference in the worksheet.
There were no Circ Reference warnings in this case, but when - in desperation - I unchecked 'Enable iterative calculation' in Excel Options/Formulas/Iterations, I suddenly got Circular Ref warnings in the Status Bar.
Clearing the circular refs, and rechecking 'Enable iterative calculation' brought everything back to normal.
So here's hoping this may help someone else puzzled why their worksheet is stuck in 'Manual' !
