Feature Summary

Calculation options are used to set the automatic/manual calculation mode for formulas, addressing issues such as formulas not updating automatically or large spreadsheets experiencing calculation lag.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Steps

Setting Automatic Calculation

Feature Entry

"Formulas" tab → "Calculation Options" dropdown menu → "Automatic" option

  1. Click the "Calculation Options" dropdown menu in the Formulas tab
  2. Select "Automatic" (default mode)
  3. Formulas will automatically recalculate and update results when data is modified

image

Setting Manual Calculation

Feature Entry

"Formulas" tab → "Calculation Options" dropdown menu → "Manual" option

  1. Click the "Calculation Options" dropdown menu in the Formulas tab
  2. Select "Manual"
  3. Formulas will not update automatically after data is modified
  4. Press Fn+F9 to manually trigger recalculation of all formulas
  5. Press Shift+Fn+F9 to recalculate only the formulas on the current worksheet

image

Automatic Except for Data Tables

Feature Entry

"Formulas" tab → "Calculation Options" dropdown menu → "Automatic Except for Data Tables" option

  1. Click the "Calculation Options" dropdown menu in the Formulas tab
  2. Select "Automatic Except for Data Tables"
  3. After data modification, formulas will update automatically, but formulas in data tables will not recalculate automatically

image

FAQ

Q1: What should I do if formula results do not update automatically after modifying data?

  • Solution: Check whether "Formulas" → "Calculation Options" is set to "Manual". Change it to "Automatic". Alternatively, press Fn+F9 to force a manual recalculation once.

Q2: What should I do if formula calculation is too slow in a large spreadsheet?

  • Solution: Set the calculation option to "Manual", and press F9 (Mac: Fn+F9) to perform a unified calculation after editing is complete. You can also use Shift+Fn+F9 to calculate only the current worksheet for a specific area.

Notes

  • In manual calculation mode, saving the file will not automatically trigger recalculation of all formulas
  • Manual mode is suitable for large spreadsheets with more than 100,000 rows of data