Making the setting go with the workbook would be tougher. The issue is
that the calculation setting (e.g. manual, automatic) is an
Application property not a workbook level one. That is, it applies to
all workbooks open in an Excel tsession (and subsequent sessions) not
just a particular workbook open in a particular session. If your
comfortable with macros, you can write a short one detect and store
the current calculation state (e.g. "bCalcState =
Application.Calculation") and if it's not what you want for your
workbook, then ask the user if they'd like to change it. If you do
this, though, you should change it back to its original state when you
close the workbook. There may be a reason, after all, a particular
user likes their Excel to be in a particular calculation mode. [And
even setting it back to the state it was when you opened the workbook
would ignore/overwrite any changes the user made manually during that
Excel session. You could do a second check of its state before you
close your workbook o trap this situation or, if you assume this kind
of change is a very low probability event, you could change it back
without asking.]

HTH
/ Tyla /


On Apr 17, 2:22 pm, clara wrote:
Hi David,

It works well. Another questio is that if this workbook is opened by another
Excel, does the setting keep going? or How can I make the setting go with the
workbook.

Clara
--
thank you so much for your help

"David Biddulph" wrote:
Tools/ Options/ Calculation:
Make sure it says Automatic, not Manual.
--
David Biddulph

"clara" wrote in message
...
Hi all,

There is simple formula =sum(A1:A10. If any of cell in range A1:A10 is
changed, how to make the cell which contain the formula display the
change?

Clara
--
thank you so much for your help