Lỗi "Excel formulas not working"

Mã lỗi:

Hướng dẫn Fix Lỗi \

• 2003: Tools > Options > Calculation > Calculation > Automatic.
• 2007: Office button > Excel options > Formulas > Workbook Calculation > Automatic.
• 2010 and newer: File > Options > Formulas > Workbook Calculation > Automatic.

On Mac:

• 2008: Excel Preferences > Calculation > Automatically

In some cases you may prefer to keep it set to manual, for example if there are many heavy calculations to perform. In such cases, you can simply press F9 when you want the calculations to update.