Excel Won't Calculate
 

I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!

Excel Won't Calculate
 

On Wed, 4 Jun 2008 17:03:02 -0700, davem97132
wrote:

I have a spreadsheet that originally worked with the formulas using basic SUM
and IFSUM. I have posted it to my web site, with protection and only left
certain cells open for editing. I recently discoverd that it is no longer
calculating. I have opened it, removed all protection, unlocked all cells
and redone some of the SUM calcs, but it still won't calc when I change the
values in the cells that are in the SUM range.

Years ago, Excel had problem if you copied the formulas too many times, it
stopped recalculating, but I am not sure what the issue with this sheet is.

I have even run the formula evaluation. When I change a single value in the
column from 0 to 1 and evaluate, the SUM still appears as 0.

Help!!!

Since there's no native IFSUM Excel function, perhaps there's something wrong
with whatever is generating that.
--ron