Here's the Microsoft page that explains how Excel operates with respect to Manual and Automatic Calculation. http://support.microsoft.com/kb/214395

Hope this helps.