Copying a formula but only getting the result

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LL - 22 May 2008 19:35 GMT

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?

Reply to this Message

T. Valko - 22 May 2008 19:43 GMT

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!

Signature

Biff
Microsoft Excel MVP

> 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
[quoted text clipped - 3 lines]
> copy to and can't re-enter my formulas in every cell. What am I doing
> wrong?

Reply to this Message

LL - 22 May 2008 19:52 GMT

Thank You so much!! That fixed it!

> Check and make sure calculation is set to automatic:
>
[quoted text clipped - 10 lines]
> > copy to and can't re-enter my formulas in every cell. What am I doing
> > wrong?

Reply to this Message

T. Valko - 22 May 2008 21:22 GMT

You're welcome. Thanks for the feedback!

Signature

Biff
Microsoft Excel MVP

> Thank You so much!! That fixed it!
>
[quoted text clipped - 16 lines]
>> > copy to and can't re-enter my formulas in every cell. What am I doing
>> > wrong?

Reply to this Message