Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Copy and drag a formula
Name: VickiMO Date: August 6, 2009 at 11:24:55 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
I want to copy and fill the formula in a column. The formula copies but my numbers don't change in the column. It works in 2003 but not in 2007.
Name: DerbyDad03 Date: August 6, 2009 at 11:28:26 Pacific
Reply:
re: but my numbers don't change in the column.
What numbers don't change?
0
Response Number 2
Name: VickiMO Date: August 6, 2009 at 11:37:30 Pacific
Reply:
My end column that I pasted the formula in to. =SUM(E2+I2) answer is 954,822 When I copy & drag down the formula I get: =SUM(E3+I3) answer is 954,822. Shd be 63,017 =SUM(E4+I4) answer is 954,822 etc
0
Response Number 3
Name: DerbyDad03 Date: August 6, 2009 at 11:49:16 Pacific
Reply:
Press F9 and tell us what happens.
0
Response Number 4
Name: VickiMO Date: August 6, 2009 at 11:51:47 Pacific
Reply:
Nothing
0
Response Number 5
Name: DerbyDad03 Date: August 6, 2009 at 12:44:28 Pacific
Reply:
In Excel 2003, if Calculation is set to Manual, you will get the symptoms you describe. The formulae will auto-fill, but the sheet won't calculate the new values.
F9 forces a calculation and the numbers will update, so I suggested F9 to see if that would work. That would have led me to conclude that Calculation is set to Manual.
Since I don't have 2007, the only things that I can suggest is to check the Calculation setting to make sure it's set to automatic and to try some other formulae and see if they udpate the values as expected.
Let us know what you find.
0
Response Number 6
Name: VickiMO Date: August 6, 2009 at 12:58:07 Pacific
Reply:
I was just looking in my formula options and I got it figured out just as you sent your reply. In 2007 in the formula's tab, it has a calculations options and yes it was set on manual. Once I clicked on automatic my numbers all were corrected. F9 did not work but when the wrong numbers came up, there was a calculate button that showed up on the bottom and that worked. I still needed to go into the calulations options and change it so it was always on. Thanks for your help!
Summary: As most of you know excel is great in that when you want to copy & paste formulas it moves the cell references. On one of my sheets I copied and pasted a formula and all the cell references changed ho...
Summary: Hi, I was reading through other posts to try to find my answer but I wasn't getting anywhere. I am creating a sheet in Excel now and, because I am not as advanced as I'd liked to be, it is taking way ...
Summary: Dear CyberSlug, I copy the formular into VBE, my next question is how to run the Module? Right now, the Sum won't update by itself, I have to go to the formula and insert a space, then it will give m...
0 
MS excel comma
