Copied formula won't calculate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I copy and paste a formula to a new cell, the new cell will show the
result from the original location.
 
What does it say in the toolbar? Sometimes it maintains a connection to the
data in the original workbook if you pasted in another.
 
When pasting do Paste special ->formulas
If you also need the formatting, use the paint brush after step above.
Also, you may want to confirm that the calculation is set to automatic. Go
to Tools ->Options and select the calculation tab. If you must leave the
calculation set to manual, use the Shift F9 key combination to calculate the
sheet where you have pasted the formula. If you hit F9 it will calculate the
whole workbook and it may take a long time to refresh.

Michael Arch.
Please rate answers
 
Turn calculation mode to automatic under Tools>Options>Calculation.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

How do I ensure formulas automatically calculate after pasting 1
Formula results don't change when it's pasted/dragged into a new c 2
Formulas displayed in cell rather than calculated values? 4
Select a range not equal to: 4
Time Sum in Excel 1
How can I change the formula for multiple cells at once? 2
Excel VBA 1
Copying formulas between sheets and keeping original ref 8

Back
Top