[AccessD] OT reference cells in Excel

Mark,

Elaborating a bit on Jim's response:

Since it's possible for another formula to have a reference to the range
of cells that you moved, either that formula or your original summary
formula would have been invalid after the move.  Excel invalidates the
range that is overwritten by displaying the #REF error as the result in
the formula that refers to the overwritten range.  Any formulas
referring to the moved range remain intact.  Copying/pasting the data
avoids this because the original data remains in place for any formulas
that rely on it.

Hope that makes sense.

Don