Software

Ask something
Discussion Locked

Excel not updating

0 helpful
6 replies

by jeff anderson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My excel formulas are not recalculating when I change the values of the range. I have no Idea how to fix this. I reinstalled sp1 (office2k) and it did not work. Heres the example of what is happening.
Cell Names A1 B1 C1
2 1 =Sum(A1:B1) or 3
New value 3 1 =Sum(A1:B1) 3 (should be 4) When I double click on it and hit enter it recalculates. HELP!!!!!

6 replies

by jeff anderson

I forgot to say that this is only happening in 1 workbook. All the sheets. All other spreadsheet docs are working fine.

Its a protected workbook by password and I was in using the password so I could modify the sheet.

This discussion is closed to new replies.