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
|