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