When I copy a formula to another cell, I get the value of the ori.

Q

queenie

I am now having a problem that has never happened before. When I copy a
formula from one cell to another, the copied cells show the value of the
original cell. I have tried the special paste option and that doesn't work
either. How can I fix this? Help
 
G

Gord Dibben

queenie

You can probably fix it by going to Tools>Options>Calculation and selecting
"Automatic"


Gord Dibben Excel MVP
 

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

Copy addition formula of non-consecutive horizontal cells 2
Drop down list control value in vba 2
Excel help needed: Skipping cell without skipping cell reference 1
Visio shape text disappears upon copy paste 1
You don't currently have permission to access this folder 0
how to copy and paste value from one sheet to another 4
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
A couple questions BEFORE using Office 365 0

Top