Common questions about Calculation Options usually involve collaboration impact, iterative calculation, and displayed precision; this FAQ includes 3 common questions and a glossary.
FAQ
Will switching the calculation mode affect other collaborators?
- Yes. This is a document-level calculation setting.
- If the workbook is switched to manual recalculation, formulas will not update immediately after other collaborators change data.
- It is a good idea to confirm whether the workbook is using automatic or manual recalculation before collaboration starts.
What should I do if a circular reference still does not converge after iterative calculation is enabled?
- Check the formula logic first and confirm that the circular reference is intentional.
- Increase Maximum Iterations so the formula has more calculation rounds.
- Adjust Maximum Error so the result can stop within an acceptable range more quickly.
What happens when I turn on precision as displayed?
- After it is enabled, cells participate in later calculations using the displayed value.
- This can help keep displayed report values aligned with later results.
- If you need to preserve higher-precision underlying results, use this option carefully.
Glossary
| Term | Definition |
|---|---|
| Iterative calculation | A calculation method that allows formulas with circular references to recalculate repeatedly until a set count or error threshold is reached. |
| Maximum error | The allowed difference between two iteration results; calculation can stop when the difference becomes smaller than this value. |
| Manual recalculation | A mode in which formulas do not update immediately after data changes and must be recalculated by the user. |