Copying Calculations

[Dave \IT\]

Hey Group,

First of all, I've done some pretty advanced programming within Excel, both
in the spreadsheet and VBA. I may just be missing an obvious, but it's
frustrating me to no end. Here's my problem.

I have a sheet of data. Nothing special, just inputted numbers. All of the
fields are Numerical, and all formatted the same way. I write a formula in
F10 that reads '=C10*E10' and it gives me my result...which is correct. I
then click-n-drag (on the bottom right corner) to copy this equation to the
next 10 cells. They all read correctly ('=C11*E11', '=C12*E12', etc.), yet
the number that appears is the same as the first result. In other words,
the formula is copied properly, but the displaying result isn't.

How can this be?

 

[J.E. McGimpsey]

Click the Automatic radio button in Tools/Options/Calculation

 

[Jon Barchenger[MS]]

Good afternoon Dave -

Hmmm - wonder if you may have overlook the calculations options?
Check and see if you're set to manual calculations.

If that is not it - maybe you could ZIP or Stuff the file and send it to me to look at.

I cannot think of anythin else right off hand.

Thanks,
Jon Barchenger
--------------------
| **From: "Dave \"IT\"" <[email protected]>
| **Newsgroups: microsoft.public.excel.worksheet.functions
| **Subject: Copying Calculations
| **Lines: 17
| **X-Priority: 3
| **X-MSMail-Priority: Normal
| **X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| **X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| **Message-ID: <[email protected]>
| **Date: Mon, 10 Nov 2003 13:33:53 -0500
| **NNTP-Posting-Host: 207.236.60.69
| **X-Complaints-To: (e-mail address removed)
| **X-Trace: news20.bellglobal.com 1068489235 207.236.60.69 (Mon, 10 Nov 2003 13:33:55 EST)
| **NNTP-Posting-Date: Mon, 10 Nov 2003 13:33:55 EST
| **Organization: Bell Sympatico
| **Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.com!prodigy.com!prodigy.com!in.100proofnews.com!
in.100proofnews.com!snoopy.risq.qc.ca!nf3.bellglobal.com!nf1.bellglobal.com!nf2.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
| **Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.worksheet.functions:170335
| **X-Tomcat-NG: microsoft.public.excel.worksheet.functions
| **
| **Hey Group,
| **
| **First of all, I've done some pretty advanced programming within Excel, both
| **in the spreadsheet and VBA. I may just be missing an obvious, but it's
| **frustrating me to no end. Here's my problem.
| **
| **I have a sheet of data. Nothing special, just inputted numbers. All of the
| **fields are Numerical, and all formatted the same way. I write a formula in
| **F10 that reads '=C10*E10' and it gives me my result...which is correct. I
| **then click-n-drag (on the bottom right corner) to copy this equation to the
| **next 10 cells. They all read correctly ('=C11*E11', '=C12*E12', etc.), yet
| **the number that appears is the same as the first result. In other words,
| **the formula is copied properly, but the displaying result isn't.
| **
| **How can this be?
| **
| **
| **