Use Recalculate with 1 how-to topic; choose it from the How-to Index and follow the entry path and steps to complete the task.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Manually trigger recalculation | Free |
How-to Guide
1. Manually trigger recalculation
Entry path: bottom toolbar Tools tab → Recalculate
- Open a spreadsheet file that contains formulas.
- Tap the Tools tab at the bottom of the screen.
- Select Recalculate.
- Check whether all formula results in the current worksheet have refreshed.
Success Criteria
- Interface result: formula results in the current worksheet are refreshed.
- Next actions available: you can continue editing data, checking results, saving, or sharing the file.
Tips While Using
- Common mistake: if the result still does not change, first check whether the edited cells are actually referenced by the formula.
- Environment note: if a cell is set to text format, the formula result may not update as expected. Change the cell to a general or numeric format and recalculate again.