Common questions about WPS Recalculate on iOS cover 3 areas: results not updating, finding the entry, and format-related calculation issues.
FAQ
What should I do if results still do not update after automatic recalculation is enabled?
- Check whether the related cells are formatted as text.
- Change the cell format to General or another suitable number format.
- Run Recalculate again and review the updated formula results.
Why can’t I find the Recalculate command?
- Make sure you opened a spreadsheet file instead of a Writer, Presentation, or PDF file.
- Tap the Tools tab at the bottom and look for Recalculate.
- If the command still does not appear, update WPS Office and reopen the file.
Does recalculation change my original data?
- Recalculation is used to refresh formula results and does not directly overwrite the values you entered manually.
- If referenced data or formats have changed, the displayed results can change accordingly.
- For important files, review key cells after recalculation and then save the file.
Glossary
| Term | Definition |
|---|---|
| Recalculate | The action of running worksheet formulas again and refreshing the displayed results. |
| Formula result | The value shown after a cell formula is calculated from referenced data. |
| Text format | A cell format that stores content as text, which can affect how values participate in calculations or how results are interpreted. |