[AccessD] OT reference cells in Excel

thanks Jim


>From: "Hale, Jim" <Jim.Hale at fleetpride.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 15:41:23 -0500
>
>don't drag, copy the values and then erase the old ones.
>Jim Hale
>
>-----Original Message-----
>From: Mark A Matte [mailto:markamatte at hotmail.com]
>Sent: Wednesday, June 14, 2006 3:20 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] OT reference cells in Excel
>
>
>Hello All,
>
>In Excel 97 I have Sheet1 and Sheet2.  On sheet2 A1=SUM(Sheet1!A1:A3)...so
>far so good...then I delete the values on sheet1...still good...then I drag
>other values(no calcs just numbers) into the cells on sheet1...here is the
>problem...sheet2 A1 now =SUM(Sheet1!#REF!)?
>
>Help???  Just curious why/something else I need?
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>***********************************************************************
>The information transmitted is intended solely for the individual or
>entity to which it is addressed and may contain confidential and/or
>privileged material. Any review, retransmission, dissemination or
>other use of or taking action in reliance upon this information by
>persons or entities other than the intended recipient is prohibited.
>If you have received this email in error please contact the sender and
>delete the material from any computer. As a recipient of this email,
>you are responsible for screening its contents and the contents of any
>attachments for the presence of viruses. No liability is accepted for
>any damages caused by any virus transmitted by this email.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com