Hi Patrick,

Thank you for the information, now I can reproduce the problem.
After I further troubleshooting, I finally find that you have set the
Calculation option to manual, and this setting is based on file.
Now to enable the auto calculation, you may follow the steps below.
1. open menu Tools/Options
2. select Calculation Tab
3, in the Calculation section, you will find the original file setting is
Manual, just set it to Automatic.

You may have a try and let me know the result.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.