WPS Calculation Options on Windows FAQ

Last updated:July 20, 2026

When using Calculation Options, common questions usually focus on collaboration impact, circular-reference convergence, and manual recalculation behavior; this FAQ includes 5 common questions and 4 glossary terms.

FAQ

Does changing the calculation mode affect other collaborators?

  1. Yes. Calculation Options is a workbook-level setting.
  2. If the workbook is switched to manual recalculation, formulas do not update automatically when other collaborators edit data.
  3. It is a good idea to confirm whether the team should use automatic or manual recalculation before collaboration starts.
  4. To restore real-time updates, switch back to automatic recalculation.

What should I do if iterative calculation does not converge?

  1. Check whether the formula logic contains an unreasonable circular reference.
  2. Increase Maximum Iterations so the model has more chances to converge.
  3. Adjust Maximum Change so iteration can stop within a practical threshold.
  4. If circular-reference calculation is not needed, clear Iterative Calculation.

How to change calculation options in WPS when automatic recalculation is too slow?

  1. Check whether the workbook contains many complex formulas or large reference ranges.
  2. During editing, switch to manual recalculation to reduce full updates after every input.
  3. After one round of edits, press F9 or click Recalculate to refresh results together.
  4. If needed, split worksheets or simplify the formula structure.

Will a new formula calculate immediately in manual mode?

  1. A newly created formula usually returns an initial result once.
  2. After that, if related data changes again, the result does not refresh automatically.
  3. You need to press F9 or Shift+F9 to update it again.
  4. If you want continuous real-time updates, switch back to automatic recalculation.

What happens after I switch back to automatic recalculation?

  1. After you return to automatic mode, the workbook resumes updating with data changes.
  2. Affected formulas recalculate again.
  3. This helps align the current results with the latest data.
  4. In large workbooks, you may need to wait for one full update to finish.

Glossary

TermDefinition
Iterative CalculationA calculation method that allows formulas with circular references to recalculate repeatedly until the result reaches the defined threshold or the iteration limit.
Maximum ChangeThe allowed difference threshold between two iteration results. When the difference becomes smaller than this value, iteration can stop.
Automatic RecalculationA mode in which related formulas update automatically when referenced data changes.
Manual RecalculationA mode in which formulas do not update immediately after data changes and require a manual recalculation command.