Jan 04 2023 07:58 AM
I have been using Excel for years, and the last few months I have had to click on the cell I want the total to update in. It will not recalculate on its own. Is there a good reason for this? Some of my spreadsheets are old and have been updated with the updated Excel versions, but the formulas have always worked before. Even a simple @sum is not working correctly... This is time consuming and frustrating if I forget to recalculate.
Jan 04 2023 08:14 AM
On the Formulas tab of the ribbon, make sure that Calculation Options is set to Automatic.
Jan 04 2023 08:53 AM
Check the status bar at the bottom of the window. Do you see 'Circular References' near the left hand side?
Jan 04 2023 01:07 PM
Thank you for the attempt. This is why I feel this is strange. I cannot see any reason why it would not be making the calculations. Many of the formulas are just adding columns and when I think the total should be correct after the last entry for the formula, I must click on the formula to get it to calculate correctly.
Jan 04 2023 02:28 PM
Does this happen in all workbooks or just in one?
Jan 04 2023 03:02 PM
Very strange. I hope that someone else will have a helpful suggestion for you.
Jan 05 2023 10:25 AM
Below the forum editor is an area to upload files.
Alternatively you can use OneDrive or another cloud service.
Jan 05 2023 11:19 AM
Jan 05 2023 12:14 PM
Jan 05 2023 01:06 PM