Autocalculate does not always work
i attached a sample file to demonstrate the issue
Table 1 are results of matches between 3 teams A, B and C
Table 2 shows the total number of win and lost matches
Table 3 makes some checks about the last table consistency : for instance number of wins and losts for all teams in table 2 are equals
In the provided file, one match is played. It is win by team A : 1 goal vs 0. Table 2 is right and table 3 shows no inconsistency
Now, modify Cell C2 with 2 : team B wins the match but in table 2, both teams are supposed to have lost
Pressing F9 forces recalculate and the results are as expected
Edited by boulshet