Absolute references between cells of a copied area will generally misbehave
unless the paste-to address agrees with the copy-from address in row, column, or
both.

An Adjust option in Paste Special would adjust all absolute references that
point from one cell in the area to another cell in an area.  (The adjustment is
like what happens today to absolute references that are affected by insertion of
rows or columns.)

While this enhancement is not a panacaea for absolute-reference problems, it
covers the important special case of copying an area that contains all the cells
upon which any cell in the area depends.