Copy formulas displaying wrong value
 

I'm copying formulas in excel, but the value of the original cell I copied
appears in all of the 'pasted' cells. However, when I select one of the
'pasted' cells, the copied formula appears in the formula bar. Therefore,
the formula is in the cell, but displaying the wrong value (the one of the
original 'copied' cell). Only after I double-click the 'pasted' cells
(one-by-one), does the formula update to display the correct value.

Any ideas of how to get rid of this? It started after I accidentally messed
around with 'sticky' keys (appears when hitting the shift key 5 times).

Copy formulas displaying wrong value
 

Hi Gitlin

It is probably because you have calculation set to manual.

Therefore change it to automatic by:

Selecting 'Options' from the 'Tools' menu and going to the 'Calculation' tab
and ticking the 'Automatic' item in the calculation area at the top.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"gitlin" wrote:

I'm copying formulas in excel, but the value of the original cell I copied
appears in all of the 'pasted' cells. However, when I select one of the
'pasted' cells, the copied formula appears in the formula bar. Therefore,
the formula is in the cell, but displaying the wrong value (the one of the
original 'copied' cell). Only after I double-click the 'pasted' cells
(one-by-one), does the formula update to display the correct value.

Any ideas of how to get rid of this? It started after I accidentally messed
around with 'sticky' keys (appears when hitting the shift key 5 times).

Copy formulas displaying wrong value
 

Thanks, Martin. That was the problem. Huge help!!


"Martin Fishlock" wrote:

Hi Gitlin

It is probably because you have calculation set to manual.

Therefore change it to automatic by:

Selecting 'Options' from the 'Tools' menu and going to the 'Calculation' tab
and ticking the 'Automatic' item in the calculation area at the top.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"gitlin" wrote:

I'm copying formulas in excel, but the value of the original cell I copied
appears in all of the 'pasted' cells. However, when I select one of the
'pasted' cells, the copied formula appears in the formula bar. Therefore,
the formula is in the cell, but displaying the wrong value (the one of the
original 'copied' cell). Only after I double-click the 'pasted' cells
(one-by-one), does the formula update to display the correct value.

Any ideas of how to get rid of this? It started after I accidentally messed
around with 'sticky' keys (appears when hitting the shift key 5 times).