Hi,

I use a mane with a relative reference to sum 3 cells to the left or
in another case
the 3rd, 6th, 9th and 12th cell to the left.
The syntax for the name is "!A1:A3" when my pointer is in A4, formula
is "=SUM(Name). I wrote it without the sheetname, because I'd like to
use it on every sheet I have in the book.
Now, when I change values in the precedent cells nothing happens until
I force a complete recalculation,
it doesn't calculate automatically, also F9 doesn't force the formula
to calculate.
Any ideas or workarrounds, especially for "3rd, 6th, 9th and 12th"
case.

Excel XP SP3
Win XP SP1


Regards
Werner