Urgent: Excel help

[DaveCSparty]

Sorry to post in here, but I'm having excel trouble here at work and can use help quickly!

Whenever I copy and paste a formula, the formula copies over fine, but it will not calculate a new value. It'll paste the formula with the value of whatever cell i copied from.

Does anyone know how to fix this? It doesn't matter what worksheet I'm in, a new one or another one. They all do this. Please help!

 

[vitoprimo]

Try "Paste Special"

 

[LeiZaK]

Where's Nik?

 

[hypn0tik]

Are you sure you are putting the '=' in front of the formula?

 

[PurdueRy]

are you using relative addressing?

 

[DaveCSparty]

yea i'm just using a regular formula. =B2+B1 (for example) and it'll copy over, but the value doesn't change

 

[hypn0tik]

Originally posted by: DaveCSparty
yea i'm just using a regular formula. =B2+B1 (for example) and it'll copy over, but the value doesn't change

See the post above. It's probably an issue of relative addressing.

Try =$B$1+$B$2

 

[DaveCSparty]

but I want the value to change

 

[PurdueRy]

send it to me rleemhui@purdue.edu and let me see

unless its top secret or something

 

[hypn0tik]

Originally posted by: DaveCSparty
but I want the value to change

What do you mean? Explain yourself better.

 

[DaveCSparty]

if I exit the spreadsheet and reopen it, the values are the correct calculated values! Why is it not "refreshing" the values when I'm working on it?

 

[PurdueRy]

go to options->calculation and make sure its set to automatic

 

[iamwiz82]

Originally posted by: DaveCSparty
if I exit the spreadsheet and reopen it, the values are the correct calculated values! Why is it not "refreshing" the values when I'm working on it?

Tools >> Options >> Calculations

Check Automatic Calculations

 

[PurdueRy]

Originally posted by: DaveCSparty
if I exit the spreadsheet and reopen it, the values are the correct calculated values! Why is it not "refreshing" the values when I'm working on it?

So....does it work now?

 

[DaveCSparty]

Originally posted by: rleemhui
go to options->calculation and make sure its set to automatic

bowdown to rleemhui and iamwiz82!! thanks y'all

 

[PurdueRy]

woohoo! Now stop ATOT'ing and GET BACK TO WORK!