Forum Discussion
Excel recalculation
I have a Excel sheet where some cells recalculate automatically and others do not and require a F9 to recalculate.
It is interesting that several totals recalculate automatically even where data cells do not!!!
The original excel sheet was built circa 2010 and has been developed since then, it is now saved in the ".xlsx" format.
New spreadsheets calculate automatically!
Any suggestions to resolve this problem?
Automatically calculate formulas...to do this,
start Microsoft Excel and click on "File > Options" in the menu bar.
In the Options dialog box, switch to the Formulas category.
In the "Workbook Calculation" area, enable the "Automatic" option.
So the automatic calculation should work again and the cells with formulas should show the correct result again when the contents/values of the reference cells change.
You could turn automatic formula calculation on and/or off automatically with VBA Code.
Private Sub Workbook_aktivate() Application.Calculation= xlautomatic End Sub Private Sub Workbook_deaktivate() Application.calculation= xlManual End SubAdditional Information:
How Excel determines the current mode of calculation
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
- Many thanks for your response.
I have reviewed the three files that have the recalculation problem and all already have the workbook calculation set on via the formula tab calculation option.
Using your suggestion I have reset auto calculation on and off several times and auto calculation seems to now be working OK.
I will be able to confirm this when I have new data to input on 28/12
Many thanks for your help on this.
Have a good new year.
D- I have today entered new data on all three spreadsheets and the recalculate problems remain. As a matter of interest I have deleted all formulas from the cells affected and then added the formulas again and unfortunately the problems remain.
Do you have any other ideas to resolve the problem?
Kind regards DBF
