Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying a formula's answer into a separate cell | Excel Worksheet Functions | |||
Copy and Paste Special (Formulas) pastes cell value if numeric | Excel Discussion (Misc queries) | |||
Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
copy worksheet with formulas but not data | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel |