Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula correct, answer wrong
I have a spreadsheet that when I copy the formula, it copies correctly
(changes the cells it should subtract), however, the result stays the same. It matches the formula I copied it from, even though the cells to calculate are now different. I even did a paste special and said only formula, but still, same result. If I actually type in the formula, it works fine, but I have a lot I need to copy and paste. Is there a way I can fix this? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula correct, answer wrong
Perhaps you have calculations set to Manual. Press F9 to confirm. Calculations should now work. To set to automatic calcs: Go to Tools|Options and in the Calculation Tab, set Calculation to Automatic. Click Ok. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=497619 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula correct, answer wrong
It sounds as though you have manual calculation set.
Go to ToolsOptionsCalculation, and click the Automatic button. -- HTH RP (remove nothere from the email address if mailing direct) "TJAC" wrote in message ... I have a spreadsheet that when I copy the formula, it copies correctly (changes the cells it should subtract), however, the result stays the same. It matches the formula I copied it from, even though the cells to calculate are now different. I even did a paste special and said only formula, but still, same result. If I actually type in the formula, it works fine, but I have a lot I need to copy and paste. Is there a way I can fix this? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with formula that unexpectedly returns an answer | Excel Worksheet Functions | |||
Formula retrieves wrong data | Excel Discussion (Misc queries) | |||
Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
Formula giving incorrect answer... | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) |