Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted formula being copied to cell
We have a Commissions spreadsheet that was created in Excel 97. We recently
upgraded to Excel 2003. There are a couple of rows in the worksheet that when data is entered into a cell and enter or tab is keyed an unwanted formula is copied to a different cell. Specifically: data is entered into cell M1229 (there is no formula there only a total for the colum in the cell underneath) in cell N1229 there is a formula =SUM(M1229*0.1) and this is fine. But in cell O1229 where there should be nothing, the formula from O1228 gets copied into that cell =SUM(M1228*1). Why is this happenening and is there anything I can do to not make this happen? Thank you for any help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted formula being copied to cell
Look under toolsoptionsedit, it might be the "Extend data range and
formulas" that spooks you? Try deselecting it. -- Regards, Peo Sjoblom "Gene" wrote in message ... We have a Commissions spreadsheet that was created in Excel 97. We recently upgraded to Excel 2003. There are a couple of rows in the worksheet that when data is entered into a cell and enter or tab is keyed an unwanted formula is copied to a different cell. Specifically: data is entered into cell M1229 (there is no formula there only a total for the colum in the cell underneath) in cell N1229 there is a formula =SUM(M1229*0.1) and this is fine. But in cell O1229 where there should be nothing, the formula from O1228 gets copied into that cell =SUM(M1228*1). Why is this happenening and is there anything I can do to not make this happen? Thank you for any help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted formula being copied to cell
Thanks, I am waiting to here back from the spreadsheet user to see if this is
our fix. "Peo Sjoblom" wrote: Look under toolsoptionsedit, it might be the "Extend data range and formulas" that spooks you? Try deselecting it. -- Regards, Peo Sjoblom "Gene" wrote in message ... We have a Commissions spreadsheet that was created in Excel 97. We recently upgraded to Excel 2003. There are a couple of rows in the worksheet that when data is entered into a cell and enter or tab is keyed an unwanted formula is copied to a different cell. Specifically: data is entered into cell M1229 (there is no formula there only a total for the colum in the cell underneath) in cell N1229 there is a formula =SUM(M1229*0.1) and this is fine. But in cell O1229 where there should be nothing, the formula from O1228 gets copied into that cell =SUM(M1228*1). Why is this happenening and is there anything I can do to not make this happen? Thank you for any help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted formula being copied to cell
It did work. Thank you so much for your prompt reply.
"Peo Sjoblom" wrote: Look under toolsoptionsedit, it might be the "Extend data range and formulas" that spooks you? Try deselecting it. -- Regards, Peo Sjoblom "Gene" wrote in message ... We have a Commissions spreadsheet that was created in Excel 97. We recently upgraded to Excel 2003. There are a couple of rows in the worksheet that when data is entered into a cell and enter or tab is keyed an unwanted formula is copied to a different cell. Specifically: data is entered into cell M1229 (there is no formula there only a total for the colum in the cell underneath) in cell N1229 there is a formula =SUM(M1229*0.1) and this is fine. But in cell O1229 where there should be nothing, the formula from O1228 gets copied into that cell =SUM(M1228*1). Why is this happenening and is there anything I can do to not make this happen? Thank you for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to execute a formula copied into an excel cell | Excel Worksheet Functions | |||
cell format changes when formula copied? | Excel Worksheet Functions | |||
My cell formula is generating an unwanted e-mail message. | Excel Worksheet Functions | |||
copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
I get a 0 value when a formula is copied to another cell | Excel Discussion (Misc queries) |