I have an ongoing problem with calculations not calculating. I have a very large workbook, 20+ sheets, I am using named formulas. I have "enable iterative calculation" checked.
The problem I have is some of the formulas do not calculate. If I use a named formula 100 times and it does calculate none of the cells using the formula calculate. If I copy the named formula from one cell to another the receiving cell will calculate but the other cell will not calculate. If I go into the named formula and make a minor change for example
formula name "Total"
actual formula =A1+B1+C1
If I go to the named formula and change the formula to =A1+B1 all the cells using that name will update with the new formula. If I add back what I removed it will recalculate with the old formula.
I am stumped, any ideas?
The problem I have is some of the formulas do not calculate. If I use a named formula 100 times and it does calculate none of the cells using the formula calculate. If I copy the named formula from one cell to another the receiving cell will calculate but the other cell will not calculate. If I go into the named formula and make a minor change for example
formula name "Total"
actual formula =A1+B1+C1
If I go to the named formula and change the formula to =A1+B1 all the cells using that name will update with the new formula. If I add back what I removed it will recalculate with the old formula.
I am stumped, any ideas?