If Google Sheets is not working—whether it won’t load, keeps crashing, or shows an error—the fix is usually a browser cache clear, a disabled extension, or a network change. Below are the most effective troubleshooting steps, ordered from quickest to most involved, that resolve the vast majority of issues.
Why Google Sheets Stops Working
Google Sheets is a cloud-based spreadsheet app, so it depends on your browser, internet connection, and Google’s servers. When something goes wrong, it’s rarely the file itself—it’s usually one of these three layers. Understanding this helps you pick the right fix instead of randomly trying things.
- Browser issues: outdated browser, corrupted cache, or a conflicting extension.
- Network issues: weak Wi-Fi, VPN interference, or a firewall blocking Google’s domains.
- Google account/server issues: temporary outages or account sync problems.
Quick Fixes to Try First
Start with these simple steps—they solve most problems in under a minute.
- Refresh the page. Press Ctrl+R (Windows) or Cmd+R (Mac). Sometimes the sheet just needs a reload.
- Check if Google Sheets is down. Visit the Google Workspace Status Dashboard (status.cloud.google.com) or search “Google Sheets down” on social media. If there’s an outage, wait it out.
- Try incognito/private mode. Open a new incognito window (Ctrl+Shift+N in Chrome, Ctrl+Shift+P in Firefox/Edge) and open the sheet there. If it works, the problem is likely a browser extension or cache.
- Restart your browser. Fully close and reopen it—this clears temporary glitches.
Clear Cache and Disable Extensions
If incognito mode works, your regular browser profile is the culprit. The two main offenders are cached data and extensions.
Clear Browser Cache
- In Chrome, click the three-dot menu → More tools → Clear browsing data.
- Set the time range to “All time.”
- Check “Cached images and files” (and optionally “Cookies and other site data” if you’re okay with logging out of sites).
- Click “Clear data.” Then reload Sheets.
Disable Extensions
- In Chrome, go to the three-dot menu → Extensions → Manage extensions.
- Toggle off all extensions, then reload Sheets.
- If Sheets works, turn extensions back on one by one to find the culprit. Common offenders are ad blockers, privacy tools, and password managers that inject scripts.
Network and Connection Fixes
If the browser isn’t the issue, your network might be. Google Sheets needs a stable connection to Google’s servers.
- Restart your router. Unplug it for 30 seconds, plug it back in, and wait for it to reconnect.
- Disable VPN or proxy. VPNs can route traffic through slow or blocked servers, causing Sheets to hang. Turn it off and try again.
- Check firewall/antivirus. Some security software blocks Google domains. Temporarily disable it (if safe) to test.
- Switch networks. If you’re on Wi-Fi, try a wired connection or your phone’s hotspot. If that works, your Wi-Fi is the issue.
Fix Specific Error Messages
Different errors have different causes. Here are the most common ones you’ll see.
- “This file is not available” – The file may be deleted, or you don’t have permission. Ask the owner to share it again.
- “We’re sorry, a server error occurred” – Usually a temporary Google issue. Wait a few minutes and reload.
- “Loading…” stuck forever – Clear cache, disable extensions, or try a different browser.
- “You don’t have permission to open this file” – Sign in with the correct Google account or request access from the owner.
- “This sheet is too large” – The file exceeds Google’s size limits (10 million cells). Try splitting the data into multiple sheets or using BigQuery.
Advanced Troubleshooting
If none of the above work, try these deeper fixes.
- Update your browser. Go to your browser’s settings → About, and check for updates. Outdated browsers often break with new Google features.
- Try a different browser. If Chrome fails, try Firefox, Edge, or Safari. If it works there, reinstall your main browser.
- Disable hardware acceleration. In Chrome, go to Settings → System → turn off “Use hardware acceleration when available.” Restart the browser.
- Reset browser settings. In Chrome, go to Settings → Reset and cleanup → Restore settings to their original defaults. This removes all extensions and resets settings.
- Check your Google account. Sign out and sign back in. Also check if you’re over storage quota (Google Drive storage full can prevent saving).
When Nothing Works: Export and Recover
If the sheet won’t open at all, you can still recover your data.
- Go to Google Drive and find the file. Right-click it → Download. This downloads an .xlsx or .ods file that you can open in Excel or LibreOffice.
- If the file is corrupted, try opening it in Excel and then re-uploading to Google Sheets.
- Check the version history: if you can open the file but it’s showing old data, go to File → Version history → See version history. You can restore a previous version.
Frequently Asked Questions
Why is Google Sheets so slow?
Large sheets (thousands of rows with complex formulas) can be slow. Try reducing the range in formulas (e.g., use A1:A1000 instead of A1:A), avoid volatile functions like NOW() and RAND(), and close unused tabs. Also check your internet speed—a slow connection makes every action lag.
Can I use Google Sheets offline?
Yes, but you need to enable offline mode first. In Google Drive settings, check the “Offline” box. Then, in Sheets, you’ll see a checkmark when you’re online. Offline changes sync when you reconnect. Note: this only works in Chrome and requires the Google Docs Offline extension.
Why does my Google Sheets keep crashing?
Crashing usually comes from too many tabs open, low memory, or an extension conflict. Close other tabs, disable extensions, and restart your browser. If it persists, try a different browser or update your graphics drivers (rarely, hardware acceleration causes crashes).
How do I recover an unsaved Google Sheet?
Google Sheets autosaves to Drive every few seconds, so unsaved changes are rare. If you closed without saving, go to the file in Drive, click “Version history” and see if the latest version has your changes. If the file was never saved, check your browser’s downloads or the “Recent” tab in Drive.
Why is my Google Sheets not saving?
This usually means you’re offline or out of storage. Check your internet connection and your Google Drive storage (Settings → Storage). If you’re over the limit, you’ll see a warning. Delete files or upgrade to free up space.
Does Google Sheets work on mobile?
Yes, there are Android and iOS apps. If the app isn’t working, update it, clear its cache (Android), or reinstall. The mobile app has fewer features than the web version, so some advanced functions may not work.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- MacBook Charger Not Working? Fix It Now
- Fix Windows Cannot Be Installed to This Disk
- Zoom on iPhone & iPad: Host or Join a Meeting
- Fix iPhone SE 4 Unable to Activate: Step-by-Step
- Keep Important Emails From Getting Buried in iPhone Mail Categories
- How to Clear RAM on iPhone: Speed It Up