Excel not auto calculating formula anymore

Question

Excel not auto calculating formula anymore

Anonymous

Hi Everyone

I have been working with an existing spreadsheet that was created a few years ago for account balancing, and was using a formula to have a rolling balance after debit and credit transactions. This was working perfectly with the calculations automatically adjusting.

This suddenly stopped calculating automatically and I had to type in columns of formulas at a time to have it calculate each entry.
The Auto calculate is still on Automatic, and nothing has changed with the data.

So I decided to create a new worksheet from scratch copying the very first formula entry from the old worksheet, but my new worksheet still does not work.
I'm not sure what has happened. I am using the latest MS Office 360 Home.

I have attached an example of the new formula and would just like to know if this looks correct.

When I input a sum in either col D21 or E21, the calculation is correctly shown in F21, but when inputting a sum in D22 or E22 the balance is not updated.

The cells within col D,E,F are formatted as accounting.

Basically I want to start with a starting balance and have all debits and credits automatically adjust the balance as it is updated.

Any guidance/suggestions would be appreciated!

Thanks

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Answer 1

HansV 462.6K

Do you see 'Circular References' in the status bar at the bottom of the worksheet window?

0 comments

Answer 2

In a relatively new worksheet (or tab) on one of my fairly large spreadsheets that I have had for years, with cells linking to values from different worksheets, that wasn’t recalculating, I also did some experimentation. By simply deleting the final number of a cell reference in the newer worksheet and then immediately adding it it back, the problem for that cell started recalculating again. So I did this for all relevant cells in the new worksheet and I’m hopeful that this unexpected “maintenance” will prevent problem from reoccurring on this bread and butter spreadsheet of mine.

Thanks for your explanation.

Answer 3

@BroganDuffy,

Well, I managed to finally sort this out myself.

It was a few years ago when I originally created the formula, so I basically forgot the "correct" procedure.

So in my case, I simply selected the last "Balance" cell entry that showed the live balance, then held and clicked all the way down the same column through many rows down and then released and pressed Enter.

This then populated the entire column below the last Balance entry which now changes the value automatically as I continue to enter my data.

Interestingly, I'm wondering if this is the right way of achieving the automatic formula?

Not sure if this is the same issue you're experiencing, but this is what worked for me.

Answer 4

Anonymous

I have the same issue with no circular references. I have been using Excel since the early 90's and never before had this problem. It makes for a lot of extra unnecessary work. I have a a one-year old MacBook Air, and this problem only started recently. HELP?

0 comments

Answer 5

Do you see 'Circular References' in the status bar at the bottom of the worksheet window?

Sorry for the late reply..

No, I don't see any Circular References.

The calculation will work correctly, but it will not follow through to the next calculation automatically without me inputting the formula again.

I used to see the "live" balance result replicated in the future rows which would update as the balance changed.

This is also a clean install, as I had to reinstall the O/S, but the issue was present prior to that.

Thanks again.

Share via

Excel not auto calculating formula anymore

5 answers