Re: Recalculation?

Indeed! Not with names like Sheet1, Sheet2, etc, but it did with A:C. Not with A:D, however.

No idea what thought is behind this.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Dave Peterson" <petersod@xxxxxxxxxxxxxxxx> wrote in message news:4695469A.77FBE8D2@xxxxxxxxxxxxxxxxxxx
| Excel added them if I didn't (xl2003).
|
|
| Niek Otten wrote:
| >
| > 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.
| > |
| > |
|
| --
|
| Dave Peterson


.