Pasting Formulas bug?

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.
 
T

Trevor Shuttleworth

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

Regards

Trevor
 
E

esadler

Trevor

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

Thanks so much for your help.
 

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

Cell shows the last typed text, no matter where it is typed 0
I cant work out what the error is. 3
Cannot paste named range formula 3
Copying Formulas 3
VLOOKUP returns formula instead of result 1
WORKDAY formulas reverting to #N/A ? 3
Excel VBA 1
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Top