Re: Recalculation?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Mike,

BTW, I don't think you need the quotes around the *** 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" <nicolaus@xxxxxxxxx> wrote in message news:eZgvbf9wHHA.3560@xxxxxxxxxxxxxxxxxxxxxxx
| 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." <MikeD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:DB71A4FD-413D-41CD-A5F0-0BE7593C3045@xxxxxxxxxxxxxxxx
|| 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.
|
|


.

Quantcast