WPS Calculation Options helps you control automatic recalculation, manual recalculation, and automatic recalculation except for data tables; this feature includes 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Calculation Options is a formula calculation control feature in WPS Spreadsheet for Windows. It helps you switch how formulas update under different workloads, so you can keep results updating during everyday editing or reduce waiting time in large workbooks by switching to manual recalculation.
Core tasks include:
- Set Automatic calculation so formula results update after data changes.
- Set Manual calculation so formulas do not recalculate immediately and can be updated with F9 or Shift+F9.
- Set Automatic Except for Data Tables so regular formulas update automatically while data tables do not recalculate automatically.
This feature is useful for budgets, summary sheets, statistical tables, and large workbooks with many formulas.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | No mandatory internet connection is required for local calculation controls |
| Other | Open a worksheet that contains formulas in WPS Spreadsheet |
Download & Installation
Before using Calculation Options, install the WPS Office desktop app for Windows and open a workbook in WPS Spreadsheet.
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Launch WPS Office, open a spreadsheet file, and confirm that the Calculation Options entry is available on the Formulas tab |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides Calculation Options on the Formulas tab, including Automatic, Manual, and Automatic Except for Data Tables. In manual mode, you can recalculate with F9 and Shift+F9. | Excel provides Automatic, Automatic Except for Data Tables, and Manual calculation options, along with manual recalculation shortcuts such as F9 and Shift+F9. | Google Sheets lets you configure recalculation behavior and iterative calculation in spreadsheet settings. | Notion formulas work on database properties and functions, but they do not provide workbook-level spreadsheet calculation mode switching. | Acrobat supports calculated PDF form fields such as sum, product, average, minimum, and maximum, but this is form-field calculation rather than workbook-level spreadsheet recalculation control. |
| WPS Advantages | Advantage: WPS keeps automatic, manual, and data-table-excluded recalculation controls in one entry point, which is practical for switching between editing speed and formula update control in desktop spreadsheets. | Compared with WPS: Excel offers broader workbook calculation controls, but its settings are oriented to Excel workbook management rather than a WPS Spreadsheet workflow. | Compared with WPS: Google Sheets supports recalculation settings, but the experience is centered on web spreadsheet settings instead of desktop-style local recalculation shortcuts. | Compared with WPS: Notion is better suited to database property logic and automation than worksheet-level recalculation control. | Compared with WPS: Acrobat calculation tools are designed for PDF forms, not for editing and recalculating large spreadsheet models. |
| Official Source | — | Excel formula recalculation | Google Sheets calculation settings | Notion formulas | Acrobat form field calculations |
Overall Conclusion
If you mainly work with desktop spreadsheets and need a direct way to balance editing speed with formula updates, WPS Calculation Options provides a clear control path. Microsoft, Google, Notion, and Adobe each support related calculation scenarios, but their products focus on different workflows such as workbook administration, web spreadsheets, databases, or PDF forms.
Use Cases
| No. | Scenario | Suitable For | Main Need | How Calculation Options Helps |
|---|---|---|---|---|
| 1 | Everyday formula editing | General office users | See updated results right after changing data | Use Automatic calculation to keep formulas updated |
| 2 | Large workbook editing | Finance and data users | Reduce delays while editing many formulas | Switch to Manual calculation and recalculate later |
| 3 | Quick review of the current worksheet | Multi-sheet users | Refresh only the active worksheet | Use Shift+F9 in manual mode |
| 4 | Full workbook refresh | Users with complex workbooks | Update all formulas at once | Use F9 in manual mode |
| 5 | Separate handling for data tables | Advanced spreadsheet users | Avoid frequent automatic recalculation in data tables | Use Automatic Except for Data Tables |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Access to Calculation Options | Available | Available |
| Automatic and manual calculation modes | Available | Available |
| Basic spreadsheet editing | Available | Available |
| Advanced PDF tools, more templates, and added office benefits | Partially limited | More benefits available |
| Cloud storage | 1 GB | 20 GB |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| You only need Calculation Options to manage formula recalculation | Free | This feature itself is available without membership |
| You also need more cloud storage, templates, or added office benefits | WPS Premium | A better fit when your work goes beyond spreadsheet recalculation controls |
How to Subscribe
- Subscribe here: Get WPS Premium
Source: WPS Office pricing page