Copying a formula but only getting the result

L

LL

I'm trying to copy a formula in my spreadsheet but when I copy it doesn't
copy the formula to another cell, it copies the result of that formula to the
cell I'm trying to copy to. I've tried paste special and choosing formula
only but it still copies the result. Please help. I have too many cells to
copy to and can't re-enter my formulas in every cell. What am I doing wrong?
 
T

T. Valko

Check and make sure calculation is set to automatic:

Tools>Options>Calculation tab>Automatic>OK

It might also be that your formula uses absolute references so the result
will always be the same. You didn't post the formula so I can't tell!
 
L

LL

Thank You so much!! That fixed it!

T. Valko said:
Check and make sure calculation is set to automatic:

Tools>Options>Calculation tab>Automatic>OK

It might also be that your formula uses absolute references so the result
will always be the same. You didn't post the formula so I can't tell!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula displays as a formula, not as its result 1
multiply formula where 1 cell has a (sumif) formula as a result 1
GETPIVOTDATE Funtion 5
Copy formulas not working 1
Problem with Copying a Simple formula 3
Excel Help to copy information from one row at a time to another sheet 1
copying the Hyperlink function result without copying the actual formula 2
count - but exclude counting cells with a formula 4

Top