Pasting Formulas bug?

  • Thread starter Thread starter esadler
  • Start date Start date
E

esadler

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.
 
Sounds as though you are in manual calculation mode ... but I'm not familiar
with Excel for the Mac.

Regards

Trevor
 
Trevor

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

Thanks so much for your help.
 
Back
Top