I have several SUM formulas that sum across numerous sheets (Example -
=SUM('Placeholder Sales A:Placeholder Sales B'!H8)). The problem is that they
will not recalculate. The Calc is on but the only way I can get them to calc
is to hit f2 while in the SUM cell and then hit Enter. Does anyone know why
they wont recalc?