i use excel 2003. have just noticed that on several of my worksheets the auto sum works but only after i have hit save. until i save any changes to the set of numbers in the auto sum do not reflect in the total. only when i hit save does the sum total adjust to the new correct number. This problem is just on the last few worksheets that i have created. On all my other worksheets the Auto SUM works correctly, showing the new total as soon as a new number is entered in the auto SUM column.
Bookmarks