I'm having a big problem with MS EXCEL

[FearM9]

Ugh.

OK...when I copy formulas from one cell to the next, the only thing that copies over is the value of the original cell.

Let's say in Column A/Row 1 I have 5 as a value. In Column A/Row 2 I have 3 as a value. In Column A/Row 3, I do SUM(A1:A2) and it gives me the value of 8.

Now let's move to Column B and basically have the same setup but have different values in Column B/Row 1 and Column B/Row 2. But when I go to copy the forumula from Column A/Row 3 into Column B/Row 3, it gives me the value in Column A/Row 3 instead of spitting out a different amount that should be correct. The formula in the cell is correct, but it just copies over the value. However if I was to delete that cell and redo it manually (doing SUM(B1:B2), it gives me the correct value.

ARGH!!!

Any clue as to WTF is going on!?! I just noticed this happening last Friday.

Thanks.

[verybdog]

Let's say in Column A/Row 1 I have 5 as a value. In Column A/Row 2 I have 3 as a value. In Column A/Row 3, I do SUM(A1:A2) and it gives me the value of 8.

Now let's move to Column B and basically have the same setup but have different values in Column B/Row 1 and Column B/Row 2. But when I go to copy the forumula from Column A/Row 3 into Column B/Row 3, it gives me the value in Column A/Row 3 instead of spitting out a different amount that should be correct. The formula in the cell is correct, but it just copies over the value. However if I was to delete that cell and redo it manually (doing SUM(B1:B2), it gives me the correct value.

ARGH!!!

Any clue as to WTF is going on!?! I just noticed this happening last Friday.

Thanks.

I did exactly what you stated here and don't have a problem.

This is my result:

A B
5 6
3 9
8 15

In my A3 cell I have "=sum(a1:a2)" in it. This was how I did it: I right clicked on the cell A3 and chose 'copy' option, then placed the cursor on cell B3, right clicked and 'paste'. It worked for me.

[FearM9]

I did exactly what you stated here and don't have a problem.

This is my result:

A B
5 6
3 9
8 15

In my A3 cell I have "=sum(a1:a2)" in it. This was how I did it: I right clicked on the cell A3 and chose 'copy' option, then placed the cursor on cell B3, right clicked and 'paste'. It worked for me.

See that's what I normally do, but as of last Friday instead of giving me a value of 15, I would get 8 when I copy. EXCEL just seems to be copying the value instead of the formula. I'll even go under "Paste Special" and choose to just copy over forumulas and it still gives me the value of the original cell.

[sarabella]

Ugh.

OK...when I copy formulas from one cell to the next, the only thing that copies over is the value of the original cell.

Let's say in Column A/Row 1 I have 5 as a value. In Column A/Row 2 I have 3 as a value. In Column A/Row 3, I do SUM(A1:A2) and it gives me the value of 8.

Now let's move to Column B and basically have the same setup but have different values in Column B/Row 1 and Column B/Row 2. But when I go to copy the forumula from Column A/Row 3 into Column B/Row 3, it gives me the value in Column A/Row 3 instead of spitting out a different amount that should be correct. The formula in the cell is correct, but it just copies over the value. However if I was to delete that cell and redo it manually (doing SUM(B1:B2), it gives me the correct value.

ARGH!!!

Any clue as to WTF is going on!?! I just noticed this happening last Friday.

Thanks.You probably don't have your formulas set to automatically calculate. You can do it manually by hitting F9 (after you paste the formula and the incorrect value shows up), or you can go into Tools, Options, Calculation and make sure that Automatic is selected.

Hope this helps!

[FearM9]

You probably don't have your formulas set to automatically calculate. You can do it manually by hitting F9 (after you paste the formula and the incorrect value shows up), or you can go into Tools, Options, Calculation and make sure that Automatic is selected.

Hope this helps!

THAT DID IT!!!! THANK YOU VERY MUCH!!!

BTW...any clue as to why it got set to "Manual"? Like I said...this only started happening last Friday.
:confused:

Anyhoo...thank you once again. You just saved me a whole lotta time on my project. WOOHOO for being at the office on Sunday!

[sarabella]

THAT DID IT!!!! THANK YOU VERY MUCH!!!

BTW...any clue as to why it got set to "Manual"? Like I said...this only started happening last Friday.
:confused:

Anyhoo...thank you once again. You just saved me a whole lotta time on my project. WOOHOO for being at the office on Sunday!
No problemo. Don't know why it happens. I blame it on the fact that Excel is made by Microsoft and things from Microsoft often do crazy things with no apparent rhyme or reason. :D But don't tell Microsoft I said that or they'll take away my certifications.