Software

Ask something
Question Locked

Calculating in Excel

0 helpful
2 replies

by paul.stevens

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a 32Mb new excel file that auto calcs but when finished calculating still sais it requires calculating again, and even when I keep re-calcing it still requires more! Please could you tell me what is causing this and how can I fully calc.

2 replies

by thumbsup2

It sounds as if one of your final calculations is changing something that another cell depends on which changes another thing because of the first change, then your final calculation sees those changes and thinks it needs to calculate again. It's a vicious circle.

Try tracing your formula dependencies and see if you can discover where the circle exists.

This discussion is closed to new replies.