How to Use WPS Calculation Options on Windows

Use Calculation Options with 4 how-to topics, including 4 free topics and 0 membership-related topics, and jump from the index to the setting you need.

How-to Index

How-to Guide

1. Open the Calculation Options entry

Entry point: Formulas tab → Calculation Options

1. Open the workbook where you want to change formula calculation behavior.
2. Click the Formulas tab at the top of the window.
3. Find the Calculation Options button on the toolbar.
4. Click it to open the Calculation Options dialog.
5. Confirm that both the Formula Calculation and Recalculation sections are visible.

Success Criteria

• UI state: The Calculation Options dialog opens successfully.
• Next actions: You can continue to set iterative calculation, displayed precision, or recalculation mode.

Tips While Using

• Common mistakes: If you are not in WPS Spreadsheet, this entry may not be visible. Open the spreadsheet component first.
• Environment limits: An editable workbook must already be open.

2. Set iterative calculation parameters

Entry point: Calculation Options dialog → Formula Calculation section

1. Open the Calculation Options dialog first.
2. In the Formula Calculation section, select Iterative Calculation.
3. Enter the number of cycles you need in Maximum Iterations, or adjust it with the control on the right.
4. Enter the allowed convergence value in Maximum Change.
5. Review the Recalculation section so the overall calculation workflow matches your needs.
6. Click OK to save the settings.

Success Criteria

• UI state: Iterative calculation is selected and the parameter values are updated.
• Next actions: Models with circular references can calculate within the defined iteration count and change threshold.

Tips While Using

• Common mistakes: Values that are too small may make convergence difficult, while values that are too large may increase calculation time.
• Environment limits: This setting is most useful when the workbook contains circular references or iterative models.

3. Turn on precision as displayed

Entry point: Calculation Options dialog → Formula Calculation section

1. Open the Calculation Options dialog.
2. In the Formula Calculation section, find Precision as Displayed.
3. Select this option.
4. Check the current decimal places or number format used by the related cells.
5. Click OK to save the setting.
6. If needed, run recalculation once to review the updated result.

Success Criteria

• UI state: The option is selected.
• Next actions: Later calculations use the displayed cell precision in the calculation flow.

Tips While Using

• Common mistakes: If you do not confirm the display format first, the result may differ from the original full-precision value.
• Environment limits: This is useful when report display values need to participate directly in later calculations.

4. Switch between automatic and manual recalculation

Entry point: Calculation Options dialog → Recalculation section

1. Open the Calculation Options dialog.
2. In the Recalculation section, choose Automatic Recalculation or Manual Recalculation.
3. Click OK to save the setting.
4. If you switch to manual recalculation, edit referenced data and notice that formulas do not update immediately.
5. Click Formulas → Recalculate, or press F9, to recalculate formulas in all worksheets.
6. Press Shift+F9 to recalculate only the active worksheet.

Success Criteria

• UI state: The selected recalculation mode takes effect, and manual mode shows a status prompt.
• Next actions: You can recalculate the whole workbook or only the active worksheet as needed.

Tips While Using

• Common mistakes: After switching to manual mode, it is easy to forget to recalculate and keep looking at old results.
• Environment limits: This workbook-level setting can affect how collaborators experience calculation updates.