L
Lisar.
When I copy and paste a formula to a new cell, the new cell will show the
result from the original location.
result from the original location.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Bundy
What does it say in the toolbar? Sometimes it maintains a connection to the
data in the original workbook if you pasted in another.
data in the original workbook if you pasted in another.
M
Michael
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
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
G
Gord Dibben
Turn calculation mode to automatic under Tools>Options>Calculation.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP