ExcelBanter - SUM Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUM Formula (https://www.excelbanter.com/excel-worksheet-functions/136912-sum-formula.html)

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?

Tools Options select Automatic OK

"DT" wrote:

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?

I've been in Excel for many years so I'm checked all the Calculation Options.
It's on Automatic and F9 and Shift-F9 will not cause the SUM to calculate.
Plus, all other formlas are working.

"Teethless mama" wrote:

Tools Options select Automatic OK

"DT" wrote:

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?