Recalculation?
Thanks for your help, Niek.
"Niek Otten" wrote:
Hi Mike,
BTW, I don't think you need the quotes around the sheet names, if there aren't any spaces in those names. I don't think it will
make a difference, but you might try.
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Niek Otten" wrote in message ...
| Hi Mike,
|
| Try rebuilding the dependency tree by pressing CTRL+ALT+SHIFT+F9 or, in older versions, by replacing all "=" by "="
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Mike D." wrote in message ...
|| Hi. I have a formula that is summing items in several worksheets. The
|| formula is:
||
|| =SUM('A:R'!D54)
||
|| The value that this formula shows is zero even though there is data in the
|| other cells. If I enter into this cell (by pressing F2) and do nothing more
|| than press the enter key, the value changes to correctly sum up the values.
||
|| Does anyone understand why this is occurring? Recalculation is set to
|| Automatic and pressing F9 does not fix this.
||
|| I have this formula replicated in about 1,000 locations throughout this
|| workbook.
||
|| Thanks,
|| Mike.
|
|
|