Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to calculate e^2 in excel | Excel Discussion (Misc queries) | |||
Excel won't calculate | Excel Discussion (Misc queries) | |||
calculate age in excel so I can add it | Excel Discussion (Misc queries) | |||
can't get excel to calculate | Excel Worksheet Functions | |||
how do i calculate in excel % Available | Excel Discussion (Misc queries) |