Forum Discussion
mooslb
Jan 04, 2023Copper Contributor
Excel formatted totals
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 ...
mooslb
Jan 04, 2023Copper Contributor
YEP, it is...
HansVogelaar
Jan 04, 2023MVP
Check the status bar at the bottom of the window. Do you see 'Circular References' near the left hand side?
- mooslbJan 04, 2023Copper ContributorI only have "Ready" and "Accessibility"
- HansVogelaarJan 04, 2023MVP
I'm afraid I'm out of ideas, sorry.
- mooslbJan 04, 2023Copper Contributor
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.