When using WPS Calculation Options, the most common questions focus on collaboration impact, iterative calculation, and recalculation efficiency; this FAQ includes 3 common questions and a glossary.
FAQ
Will switching the calculation mode affect other collaborators?
- Yes. Calculation Options works as a workbook-level setting in this workflow, so changing it affects how the current shared workbook recalculates.
- If the workbook is set to manual recalculation, formula results will not update immediately after someone edits data.
- Confirm the change with collaborators first so everyone works with the same expectation for formula updates.
What should I do if a circular reference still does not converge after iterative calculation is enabled?
- Review the formula logic first and confirm that the circular reference is intentional.
- Increase Maximum Iterations if the model needs more calculation rounds.
- Adjust Maximum Error within an acceptable range if convergence can be less strict.
- If the scenario does not require circular-reference calculation, clear Iterative Calculation.
How can I handle slow automatic recalculation in a large worksheet?
- Check whether the worksheet contains many dependent formulas or complex references.
- During bulk edits or data entry, switch temporarily to manual recalculation.
- After the edits are complete, use F9 or Shift+F9 to recalculate.
- If needed, simplify formula dependencies or split the worksheet into smaller parts.
Glossary
| Term | Definition |
|---|---|
| Iterative calculation | A method that repeatedly recalculates a circular-reference formula until it approaches a result. |
| Maximum error | The allowed difference between two iteration results before the iteration can stop. |
| Manual recalculation | A mode in which formulas do not update immediately after edits and must be recalculated by the user. |