Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied formula won't calculate
When I copy and paste a formula to a new cell, the new cell will show the
result from the original location. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied formula won't calculate
What does it say in the toolbar? Sometimes it maintains a connection to the
data in the original workbook if you pasted in another. -- -John Please rate when your question is answered to help us and others know what is helpful. "Lisar." wrote: When I copy and paste a formula to a new cell, the new cell will show the result from the original location. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied formula won't calculate
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 "Lisar." wrote: When I copy and paste a formula to a new cell, the new cell will show the result from the original location. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copied formula won't calculate
Turn calculation mode to automatic under ToolsOptionsCalculation.
Gord Dibben MS Excel MVP On Wed, 1 Aug 2007 09:08:03 -0700, Lisar. wrote: When I copy and paste a formula to a new cell, the new cell will show the result from the original location. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unwanted formula being copied to cell | Excel Discussion (Misc queries) | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
how to calculate the sum of the data copied from the net? | Excel Worksheet Functions | |||
Excel formula copied down | Excel Discussion (Misc queries) | |||
I get a 0 value when a formula is copied to another cell | Excel Discussion (Misc queries) |