| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exel 2003 Copy Formula Problem
I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only copy the value that the original cells sum equals. Not the formula itself. Format for cells is set as number. Any suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exel 2003 Copy Formula Problem
Check if your calc mode is set to Auto.
<Tools <Options <Calculation tab, And make sure Auto is checked. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "addison" wrote in message ... I have used Exel for years and never experienced this issue. I am trying to simply copy (drag) a formula from one cell down the column and it will only copy the value that the original cells sum equals. Not the formula itself. Format for cells is set as number. Any suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exel 2003 Copy Formula Problem
I think it is probably copying the formula but sounds like calculation is set to
manual. ToolsOptionsCalculationAutomatic. Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 08:31:01 -0800, addison wrote: I have used Exel for years and never experienced this issue. I am trying to simply copy (drag) a formula from one cell down the column and it will only copy the value that the original cells sum equals. Not the formula itself. Format for cells is set as number. Any suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exel 2003 Copy Formula Problem
That was it!
Thank you! "Gord Dibben" wrote: I think it is probably copying the formula but sounds like calculation is set to manual. ToolsOptionsCalculationAutomatic. Gord Dibben MS Excel MVP On Wed, 12 Dec 2007 08:31:01 -0800, addison wrote: I have used Exel for years and never experienced this issue. I am trying to simply copy (drag) a formula from one cell down the column and it will only copy the value that the original cells sum equals. Not the formula itself. Format for cells is set as number. Any suggestions? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Exel 2003 Copy Formula Problem
That was the problem!
Thank you! "RagDyeR" wrote: Check if your calc mode is set to Auto. <Tools <Options <Calculation tab, And make sure Auto is checked. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "addison" wrote in message ... I have used Exel for years and never experienced this issue. I am trying to simply copy (drag) a formula from one cell down the column and it will only copy the value that the original cells sum equals. Not the formula itself. Format for cells is set as number. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007/2003 compatibility problem - copy and paste | Excel Discussion (Misc queries) | |||
| Exel 2003 | Excel Discussion (Misc queries) | |||
| Copy and paste problem Excel 2003 to Word 2003 | Excel Discussion (Misc queries) | |||
| how to auto save in exel 2003 | Excel Discussion (Misc queries) | |||
| How to use exel 98 -02 -2003 if i have xp program? | Excel Discussion (Misc queries) | |||
Linear Mode
