Pasting Formulas bug?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

esadler@colorado.edu - 16 Sep 2006 22:09 GMT

I seem to be having a strange problem with my Excel (11.2.5) for Mac.
I have pasted formulas for years and never had an issue...until now.
The formulas are simple (addition, subtraction, etc.). I copy the
formula in a cell and paste it to a new one (I even do this with Paste
Special...Formula). What appears in the spreadsheet is the value of
the original cell, not the result of the "relative" formula -- even
though the formula bar displays the correct "relative" formula. I can
only get the correct value in the new cell if I go into the formula bar
and press return at the end of the formula.

Reply to this Message

Trevor Shuttleworth - 16 Sep 2006 22:14 GMT

Sounds as though you are in manual calculation mode ... but I'm not familiar
with Excel for the Mac.

Regards

Trevor

>I seem to be having a strange problem with my Excel (11.2.5) for Mac.
> I have pasted formulas for years and never had an issue...until now.
[quoted text clipped - 5 lines]
> only get the correct value in the new cell if I go into the formula bar
> and press return at the end of the formula.

Reply to this Message

esadler@colorado.edu - 16 Sep 2006 23:10 GMT

Trevor

Yes, this worked! I had never heard of manual vs. automatic
calculation.

Thanks so much for your help.

> Sounds as though you are in manual calculation mode ... but I'm not familiar
> with Excel for the Mac.
[quoted text clipped - 12 lines]
> > only get the correct value in the new cell if I go into the formula bar
> > and press return at the end of the formula.

Reply to this Message

Trevor Shuttleworth - 17 Sep 2006 17:53 GMT

You're welcome. Thanks for the feedback

Regards

Trevor

> Trevor
>
[quoted text clipped - 20 lines]
>> > only get the correct value in the new cell if I go into the formula bar
>> > and press return at the end of the formula.

Reply to this Message