Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problemsOn a computer, open your spreadsheet and go to File > Settings > Calculation. Choose Automatic or Manual, then select Save settings. These settings apply to the entire spreadsheet, so they affect collaborators too. Use the separate iterative-calculation control when a formula relies on a circular reference.
How do I change calculation settings in Google Sheets?
- Open the spreadsheet in Google Sheets on a computer.
- Select File > Settings > Calculation.
- Under Calculation Mode, choose Automatic or Manual.
- Select Save settings to apply the change.
Calculation settings are spreadsheet-wide, not personal preferences: changing them affects everyone working in that file. Manual calculation is available to spreadsheet editors and is not available in the mobile app. See Google’s calculation settings help for the current interface details.
As an Amazon Associate I earn from qualifying purchases.
Automatic or Manual: which calculation mode should I use?
| Mode | When results recalculate | Workflow trade-off |
|---|---|---|
| Automatic | As you make spreadsheet changes. | Results update during your work, without a separate calculation step. |
| Manual | When an editor selects Calculate at the top of the screen. | You decide when to refresh calculations, but values can remain out of date until you calculate them. |
There is no universally best mode: choose based on whether you need results to update as you work or prefer to trigger calculation yourself. If you use Manual, calculate before relying on results after making changes.
How do I turn on iterative calculation?
Iterative calculation allows Sheets to handle formulas that refer back to themselves, directly or through other cells. In File > Settings > Calculation, enable Iterative calculation, then set the maximum number of iterations and the convergence threshold for your formula. Save the settings.
What the two controls do
- Maximum iterations sets the upper limit on how many calculation rounds a circular reference can run.
- Convergence threshold lets Sheets stop earlier when successive results differ by less than the threshold.
The right values depend on the formula and the output you need. Google’s December 6, 2016 announcement explains the purpose of both controls; because that announcement is historical, use the current Calculation settings panel for the available controls rather than assuming a particular default. Validate the resulting values for your spreadsheet instead of choosing a number by rule of thumb.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Why is my formula not recalculating?
First check whether the spreadsheet is set to Manual. In that mode, an editor must select Calculate for results to update. If the value comes from an external-data function, its refresh schedule may be longer than an ordinary local recalculation:
| Function | Documented refresh timing |
|---|---|
IMPORTRANGE |
30 minutes |
IMPORTHTML, IMPORTFEED, IMPORTDATA, and IMPORTXML |
1 hour |
GOOGLEFINANCE |
May be delayed up to 20 minutes |
These are refresh intervals listed in Google Docs Editors Help, not guarantees that changing calculation mode will force an immediate update.
The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →If the spreadsheet feels slow
Changing calculation mode is not a universal performance fix. Google notes that editing a cell can make Sheets evaluate that cell and its dependent cells. Volatile functions such as TODAY, NOW, and RAND, as well as long dependency chains, can add calculation work. Review whether those formulas and dependencies are necessary in the parts of the sheet that are slow. Google’s performance guidance discusses these factors.
Quick Recap
Rank #4
- Funny Kawaii Cat Calendar 2026: 12-Month Fun Art + 12-Page Productivity System: Step into a complete productivity + aesthetic experience with this 10x5 spiral-bound desktop set that merges adorable seasonal artwork with powerful dark-mode cheat sheets. The front half features twelve beautifully illustrated Kawaii cat scenes. Each monthly layout offers a clean desk calendar 2026 structure designed for quick planning at a glance.
- Excel Shortcut Desk Pad: The second half includes twelve richly colored, productivity cheats designed like a high-contrast Excel cheat sheet desk pad set. These include the full Excel cheat sheet with clearly labeled categories for formulas, navigation, formatting, and time-saving commands. Additional pages contain Google Sheets hotkeys, Gmail shortcuts, Windows key combinations, Python references, and Photoshop workflow accelerators, giving you a complete command center.
- Printed on thick 270 gsm stock in 10x5 in with soft themed illustrations inspired by modern workspace aesthetics and subtle “cat-style” accents similar to trending funny desk calendar 2026 designs. Crisp lines, rich color, and sturdy material ensure long-lasting durability throughout the entire year of daily flipping.
- Every cheat-sheet spread includes a QR code linking to exclusive productivity hacks, planning templates, routines, and efficiency tips. Works perfectly alongside the mini desk calendar 2026 style design, giving you fast, accessible guidance that elevates your time management, study habits, and project planning.
- Compact 10" x 5" spiral-bound flip format built from heavy 270 gsm stock for daily use; the top-bound coil allows clean page turns and upright placement on any counter or workstation — perfect as a mini desk calendar, small desk calendar 2026-2027, or mini desk calendar 2026 that fits beside keyboards and laptops.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
