| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a formula but only getting the result
I'm trying to copy a formula in my spreadsheet but when I copy it doesn't
copy the formula to another cell, it copies the result of that formula to the cell I'm trying to copy to. I've tried paste special and choosing formula only but it still copies the result. Please help. I have too many cells to copy to and can't re-enter my formulas in every cell. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a formula but only getting the result
Check and make sure calculation is set to automatic:
ToolsOptionsCalculation tabAutomaticOK It might also be that your formula uses absolute references so the result will always be the same. You didn't post the formula so I can't tell! -- Biff Microsoft Excel MVP "LL" wrote in message ... I'm trying to copy a formula in my spreadsheet but when I copy it doesn't copy the formula to another cell, it copies the result of that formula to the cell I'm trying to copy to. I've tried paste special and choosing formula only but it still copies the result. Please help. I have too many cells to copy to and can't re-enter my formulas in every cell. What am I doing wrong? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a formula but only getting the result
Thank You so much!! That fixed it!
"T. Valko" wrote: Check and make sure calculation is set to automatic: ToolsOptionsCalculation tabAutomaticOK It might also be that your formula uses absolute references so the result will always be the same. You didn't post the formula so I can't tell! -- Biff Microsoft Excel MVP "LL" wrote in message ... I'm trying to copy a formula in my spreadsheet but when I copy it doesn't copy the formula to another cell, it copies the result of that formula to the cell I'm trying to copy to. I've tried paste special and choosing formula only but it still copies the result. Please help. I have too many cells to copy to and can't re-enter my formulas in every cell. What am I doing wrong? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a formula but only getting the result
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "LL" wrote in message ... Thank You so much!! That fixed it! "T. Valko" wrote: Check and make sure calculation is set to automatic: ToolsOptionsCalculation tabAutomaticOK It might also be that your formula uses absolute references so the result will always be the same. You didn't post the formula so I can't tell! -- Biff Microsoft Excel MVP "LL" wrote in message ... I'm trying to copy a formula in my spreadsheet but when I copy it doesn't copy the formula to another cell, it copies the result of that formula to the cell I'm trying to copy to. I've tried paste special and choosing formula only but it still copies the result. Please help. I have too many cells to copy to and can't re-enter my formulas in every cell. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Odd result when copying functions | Excel Worksheet Functions | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| Copying result of formula into another worksheet??? | Excel Discussion (Misc queries) | |||
| How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
| copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
Linear Mode
