A slow spreadsheet may be spending time on large ranges, repeated calculations, imports, or formatting rules. Locate the expensive work before deleting historical data or replacing formulas with constants.
Establish a repeatable symptom
Record which action is slow: opening, editing one input, recalculating, or fetching external data. Compare the same operation in a controlled copy while preserving the original workbook.
A green progress bar means Sheets is working; it does not identify the bottleneck or prove that data failed to save. Check saved-state warnings separately.
Reduce unnecessary calculation work
Review whole-column formulas when a maintained bounded range would suffice. Move repeated expensive subexpressions into shared helper cells. Consolidate unnecessary repeated volatile functions such as NOW or TODAY where that preserves the intended behavior.
Inspect long dependency chains and redundant imports. Review overlapping or duplicate conditional-formatting rules, removing only those whose behavior is unnecessary. Do not delete useful rules indiscriminately.
Measure correctness as well as speed
Change one factor in the test copy and repeat the same operation. Compare key results, record counts, and known totals. Faster output is not an improvement if a smaller range silently excludes new records.
Use static snapshots only when the workflow actually requires static data, and label that change explicitly. Keep source provenance and refresh expectations. File-size limits, device resource constraints, network delay, and formula complexity are different issues, so avoid attributing every slow action to the largest visible tab. Preserve the original until the revised design is both measurably useful and reconciled with the required calculations.
References
- Learn how to improve Sheets performance
- Optimize your data references to improve Sheets performance
- IMPORTRANGE
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.