Lori,

my intention is to use a general formula in order to sum 3 cells to
the left of the active cell
and this formula should work on every sheet (I need this type of
formula some hundred times on some 20 sheets).
So I have learned from John Walkenbachs Formula Book, that I have to
use a relative name like ="!A1:!C1",
when my active cell is "D1" and to write D1=SUM(Name). This type of
formula recalculates automatically.
But when I use this expression for a relative name "!A1,!C1,!
E1" (every second cell) and my active cell is "F1"
than it only recalculates when I use "Ctrl Alt F9". I know this but my
user don't know it.
This behaviour is strange and I don't understand it.

Regards
Werner