| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
EXCEL 2007 no longer add properly
In cell k17 I have the number 1
in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
Hi,
Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
Since it is 2007 it's office buttonexcel optionsformulasworkbook
calculation and automatic -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi, Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
bingo. and thanks
"Peo Sjoblom" wrote: Since it is 2007 it's office buttonexcel optionsformulasworkbook calculation and automatic -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi, Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
THis is really different.
I did as you suggested and sure enough the setting was set to MANUAL. I then when to EXCEL OPTIONS/FORMULAS and selected AUTOMATIC and save all. then I went to the main page and clcicked on CVALCULATION(under Formalas) and selected AUTOMATIC. All worked very well. Save the workbook and closed. When I reopened the work book al the settingwere re set to MANUAL. Can you help Thanks "Peo Sjoblom" wrote: Since it is 2007 it's office buttonexcel optionsformulasworkbook calculation and automatic -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi, Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
Hi
Is it the first workbook you opened in that Excel session? The setting is taken from the first workbook opened. If you have a file that is being opened automatically when Excel starts, then ensure that it's settings are set to Automatic Calculation, then Save it. -- Regards Roger Govier "pcor" wrote in message ... THis is really different. I did as you suggested and sure enough the setting was set to MANUAL. I then when to EXCEL OPTIONS/FORMULAS and selected AUTOMATIC and save all. then I went to the main page and clcicked on CVALCULATION(under Formalas) and selected AUTOMATIC. All worked very well. Save the workbook and closed. When I reopened the work book al the settingwere re set to MANUAL. Can you help Thanks "Peo Sjoblom" wrote: Since it is 2007 it's office buttonexcel optionsformulasworkbook calculation and automatic -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi, Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
good stuff...thanks
"Roger Govier" wrote: Hi Is it the first workbook you opened in that Excel session? The setting is taken from the first workbook opened. If you have a file that is being opened automatically when Excel starts, then ensure that it's settings are set to Automatic Calculation, then Save it. -- Regards Roger Govier "pcor" wrote in message ... THis is really different. I did as you suggested and sure enough the setting was set to MANUAL. I then when to EXCEL OPTIONS/FORMULAS and selected AUTOMATIC and save all. then I went to the main page and clcicked on CVALCULATION(under Formalas) and selected AUTOMATIC. All worked very well. Save the workbook and closed. When I reopened the work book al the settingwere re set to MANUAL. Can you help Thanks "Peo Sjoblom" wrote: Since it is 2007 it's office buttonexcel optionsformulasworkbook calculation and automatic -- Regards, Peo Sjoblom "ShaneDevenshire" wrote in message ... Hi, Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
EXCEL 2007 no longer add properly
bingo and thanks
"ShaneDevenshire" wrote: Hi, Did you recalcule the spreadsheet - press F9? If this is the problem, then choose Tools, Options, Calculation, Automatic -- Thanks, Shane Devenshire "pcor" wrote: In cell k17 I have the number 1 in cell l17 I have the number 2 in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be) Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20 and l20 What has gone wrong? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why patterns are no longer available in Excel 2007? | Charts and Charting in Excel | |||
| Excel 2007 Does Not Open Properly | Excel Discussion (Misc queries) | |||
| Excel 2007 labels in functions no longer supported! | Excel Worksheet Functions | |||
| Excel 2007 Beta - help no longer functions | Excel Discussion (Misc queries) | |||
| PAGE PREVIEW NOT WORKING PROPERLY IN EXCEL 2007 | Excel Worksheet Functions | |||
Hybrid Mode
