Proofstate not updating
Can you check and make sure the data in there is all still numerical?
I think I've noticed this happening for me when I threw in a value once that was "$xyz" as opposed to "xyz" (I mean xyz to be some integer, of course). I suggest you copy your formula into Notepad, then type any number into the cell.
To do this, on the Site Actions menu, click Site Permissions, and then click Check Permissions.
The All People group is hidden in Share Point 2010.
Before you remove the user's permissions and re-add them, note the user's permissions.Usually changing the "Workbook Calculation" option (Excel 2010) solves the problem, but if it didn't, probably the workbook itself is set to manual calculation.To change this, open the workbook, select the "Formula" tab (Alt M), then click "Calculation Options" and the select "Automatic". I think this can happen when you end up with different data types in the fields in the given range.After that, click on the cell and paste your formula into the formula bar and hit enter. While working on HTML I and testing offline, you know changing the code and refreshing the browser, nothing is happening anymore. We're looking for long answers that provide some explanation and context. I use a private window or icognito as in Chrome so its not cached.