[AccessD] OT reference cells in Excel

Don,

Thanks for the explanation.  That makes sense....I was ok with the 'don't do 
that' answer...but this helps.

Thanks,

Mark A. Matte


>From: "Mcgillivray, Don [IT]" <Donald.A.McGillivray at sprint.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] OT reference cells in Excel
>Date: Wed, 14 Jun 2006 16:58:19 -0500
>
>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
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com