This FAQ covers common issues with WPS Calculation Options on macOS, including formulas not updating, recalculation speed, and active-sheet refresh methods, plus a short glossary.
FAQ
What should I do if formula results do not update automatically after editing data?
- Click the Formulas tab.
- Open Calculation Options and check whether the current mode is Manual.
- If you want automatic updates, switch it to Automatic.
- If you want to keep Manual mode for now, press Fn+F9 to recalculate all formulas.
How to speed up formula calculation in a large spreadsheet?
- Open Formulas → Calculation Options.
- Select Manual to reduce automatic recalculation during editing.
- After one round of edits, press Fn+F9 to recalculate everything.
- If you only need to check the active worksheet, press Shift+Fn+F9.
How do I update only the active worksheet in Manual calculation mode?
- First confirm that the current mode is Manual.
- Keep the cursor on the worksheet you want to process.
- Press Shift+Fn+F9.
- Check whether formulas on the active worksheet have refreshed.
Glossary
| Term | Definition |
|---|---|
| Automatic calculation | Formula results recalculate and display automatically after related data changes. |
| Manual calculation | Formula results do not refresh immediately after data changes and require manual recalculation. |
| Data table | A worksheet area used for specific analysis or what-if calculation scenarios that can be excluded from automatic recalculation in some modes. |