Can't help you with Excel I'm sorry. I've got it but never used it myself. My daughter and son would know more but it's only early morning (Tuesday) in Australia and they're both asleep.
Have you tried the Excel Help Feature? Up the top of the Excel screen, there's a tab that says Help. If you click on that it'll bring up a tiny search screen. I wrote in "Auto Calculate" and it brings up numerous options.
Also found this...
Using the Auto Calculate Feature
Quote:
|
Few Excel users notice that when they select a range of cells that contain values, the status bar displays the sum of those values, as shown in Figure 6.6. This feature provides you with a quick total of any values in the worksheet without your having to use a calculator.
|
http://safari.adobepress.com/0789729415/ch06lev1sec6
If your workbook is set to manual Calc and you are wanting it set to Auto Calc, there's something here...
http://www.eggheadcafe.com/software/...rning-off.aspx