Dec 21 2022 05:42 AM
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?
Dec 21 2022 10:59 AM
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 Sub
Additional 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)
Dec 27 2022 04:31 AM
Dec 29 2022 07:26 AM
Dec 29 2022 09:01 AM
Dec 30 2022 06:24 AM
Pls find attached one of the workbooks that I have problems with. I have deleted sensitive columns along with worksheets including graphs etc.
Each day I enter values in the date columns e.g. DFY39 DFY49 .... DFYx9.
The change is calculated immediately in DFY40 etc as you would expect. However, the Profit / Loss box DFY42 etc does not in most cells automatically calculate. To recalculate I have to press F9 or save the workbook.
What is interesting is that the Total in DFY3 etc does automatically recalculate even though the DFY42 cells do not show the new calculated values.
You will see that I am running MS 365 Excel version 2211 (build 15831.20208). My PC is a 12 month old HP Pavilion and the workbook is saved directly to the hard drive in the PC. Windows 11 is used. Please let me know if any further information is required
Any help in this matter would be much appreciated. Similarly I would appreciate you erasing the work book when we have resolved the issue.
Many thanks. DBF
Dec 31 2022 01:31 AM