When using WPS Calculation Options, users often ask about 3 issue types: formulas not updating automatically, slow calculation in large spreadsheets, and refreshing only part of the workbook; this section includes 3 common questions and a glossary.
FAQ
What should I do if formula results do not update automatically after I change data?
- Click the Formulas tab and open Calculation Options.
- Check whether the workbook is currently set to Manual.
- If you want live updates, switch it to Automatic.
- If you want to keep manual mode, press F9 once to recalculate all formulas.
How can I reduce slow formula calculation in-a-large-spreadsheet
- Open Calculation Options on the Formulas tab.
- Switch the mode to Manual.
- Finish your data entry or batch edits first.
- When editing is complete, press F9 to recalculate the workbook, or press Shift+F9 to recalculate only the current worksheet.
How do I refresh only the current worksheet in manual calculation mode?
- Confirm that the workbook is already set to Manual.
- Switch to the worksheet that you want to update.
- Press Shift+F9.
- Check whether the formula results on the current worksheet have refreshed.
Glossary
| Term | Definition |
|---|---|
| Automatic calculation | A mode in which formula results update automatically after related data changes. |
| Manual calculation | A mode in which formula results do not update immediately and require manual recalculation. |
| Data table | A calculation table used in analysis scenarios that can be excluded from automatic recalculation in some modes. |
| F9 | A shortcut key used to recalculate formulas in the workbook manually. |
| Shift+F9 | A shortcut key used to recalculate formulas in the current worksheet manually. |