G Guest Jan 14, 2004 #1 I entered a SUM formula and when I change the contents in its range the total is not updated. Any ideas?
I entered a SUM formula and when I change the contents in its range the total is not updated. Any ideas?
B Bingo Jan 14, 2004 #2 One possible answer is that calculations is on the manual setting. To check this do the followin: Click: Tools--->Options---->Calculations Tab Here the circle with automatic should be selected. Hope that helps.
One possible answer is that calculations is on the manual setting. To check this do the followin: Click: Tools--->Options---->Calculations Tab Here the circle with automatic should be selected. Hope that helps.
