Google Sheets Crashing? Here’s The Fix

Google Sheets is crashing, tabs reload, the browser freezes, or the file won’t open/respond.
This usually happens with large files, heavy formulas, or browser/memory limits being exceeded.

This guide fixes it step by step.

Why the Issue Happens

• Extremely large datasets (50k–100k+ rows with formulas)
• Full-column references (A:A, B:B) across multiple formulas
• Too many volatile functions (NOW, RAND, TODAY)
• Heavy use of ARRAYFORMULA, QUERY, or nested formulas
• Multiple IMPORTRANGE / external data connections
• Excess conditional formatting rules
• Too many open tabs/extensions in browser
• Corrupted sheet or session issues

Step-by-Step Fixes

Step 1: Open in Incognito Mode (Immediate Fix)

This bypasses extensions and cached issues.

Fix:

• Open Chrome → Incognito
• Load the sheet

If it works, issue = extensions or cache.

Step 2: Remove Full Column References

Major crash trigger.

Wrong:

=SUM(A:A)

=VLOOKUP(A2, A:B, 2, FALSE)

Fix:

=SUM(A2:A1000)

=VLOOKUP(A2, A2:B1000, 2, FALSE)

Step 3: Reduce Volatile Functions

Functions like:

=NOW()
=RAND()
=TODAY()

recalculate constantly → crashes.

Fix:

• Use once in helper cell
• Reference it elsewhere

Step 4: Limit ARRAYFORMULA Usage

Heavy arrays slow and crash Sheets.

Wrong:

=ARRAYFORMULA(A2:A * B2:B)

Fix:

=ARRAYFORMULA(A2:A1000 * B2:B1000)

Step 5: Reduce IMPORTRANGE and External Calls

Multiple imports overload the file.

Fix:

• Import once:

=IMPORTRANGE("FILE_ID", "Sheet1!A:D")

• Use local references afterward

Step 6: Delete Unused Rows and Columns

Sheets often contain thousands of empty rows.

Fix:

• Select unused rows → Delete
• Select unused columns → Delete

This reduces memory load.

Step 7: Remove Excess Conditional Formatting

Too many rules cause rendering crashes.

Fix:

• Reduce number of rules
• Apply only to required range

Step 8: Convert Formulas to Values

If data doesn’t need to update:

Fix:

• Copy → Paste special → Values only

This reduces calculation load significantly.

Step 9: Split Large Files

If sheet is too heavy:

Fix:

• File 1 → Raw data
• File 2 → Processing
• File 3 → Dashboard

Prevents overload.

Step 10: Optimize Browser

Crashes are often browser-related.

Fix:

• Close unused tabs
• Disable extensions
• Clear cache
• Use Chrome/Edge
• Restart browser

Common Mistakes

• Using full-column formulas everywhere
• Overusing volatile functions
• Running multiple IMPORTRANGE calls
• Keeping unnecessary rows/columns
• Using complex nested formulas unnecessarily
• Applying formatting to entire sheet
• Ignoring browser limitations

Pro Tips / Better Alternatives

Use QUERY Instead of Multiple Formulas

=QUERY(A1:D1000, "SELECT A, SUM(B) GROUP BY A", 1)

Reduces calculation load.

Use FILTER Instead of Nested IF

=FILTER(A2:C1000, B2:B1000="Sales")

Cleaner and faster.

Use Helper Columns

Break logic:

• Column B → step 1
• Column C → step 2

Faster than one large formula.

Archive Old Data

Move unused data to another file:

• Keeps working file lightweight

Monitor File Complexity

If performance drops:

• Reduce formulas
• Simplify structure
• Limit dataset size

Bottom Line

If Google Sheets is crashing, fix in this order:

1. Open in Incognito (check browser issue)
2. Remove full-column references
3. Reduce volatile functions
4. Limit ARRAYFORMULA and heavy formulas
5. Consolidate IMPORTRANGE usage
6. Delete unused rows/columns

Most crashes come from overloaded formulas and browser memory limits.
Optimize those, and your sheet will run reliably.