How to Fix Google Sheets Stuck on “Loading…” or Not Opening Spreadsheets

Collaborating on budgets, inventory trackers, and project management spreadsheets in Google Sheets is generally rapid and dependable. However, one of the most paralysing glitches occurs when you open a spreadsheet link or click a file in Google Drive, only for the browser tab to freeze indefinitely displaying a green progress bar or an endless banner stating: “Loading…” or “Still loading, please wait…” The grid cells never populate, menu items remain greyed out, and you cannot edit or export your data. When Google Sheets hangs on loading, your data is completely secure in Google’s cloud; rather, the issue is typically caused by corrupted browser service worker caches, aggressive privacy extensions, or offline sync token conflicts.

Force a Hard Refresh to Clear Stalled Web Assets

Web browsers frequently cache JavaScript frameworks locally to speed up daily access. If an incremental Google Sheets update was interrupted by a micro-network disconnection, the browser attempts to execute fragmented code, leading to an infinite loading spinner.

  1. With the stuck Google Sheets tab open, hold down Ctrl (or Shift on Mac) and press F5 on your keyboard (or press Ctrl + Shift + R).
  2. This command executes a “Hard Refresh”, instructing the browser to ignore its local cache and request a fresh copy of the application code directly from Google’s servers.
  3. In many instances, the green progress bar will zip across the screen and load your spreadsheet cells in seconds.

Hard refreshing flushes hanging script states and pulls clean, uncorrupted web modules from Google’s content delivery network.

Test in Incognito Mode to Isolate Third-Party Extension Conflicts

Third-party browser extensions—specifically ad blockers, cookie managers, and custom script blockers—often mistake Google Sheets’ real-time WebSocket synchronisation calls for invasive tracking scripts, severing the connection before the grid can render.

  1. Open a new Incognito window in Google Chrome by pressing Ctrl + Shift + N (or Command + Shift + N on Mac).
  2. Sign into your Google Account and open the problematic Google Sheets file.
  3. If the spreadsheet loads swiftly and completely in Incognito mode, an installed extension is responsible for the freeze.
  4. Return to your standard browser window, type chrome://extensions in the address bar, and disable your ad-blocking or privacy extensions one by one to pinpoint the conflicting tool.
  5. Add docs.google.com to your ad blocker’s trusted allowlist.

Allowlisting Google Docs and Sheets domains prevents security filters from throttling real-time cloud data streams.

Clear Site-Specific Cookies and Service Worker Storage

Rather than wiping your entire browser history and clearing passwords across all websites, you can purge cached data specifically for Google Docs and Sheets.

  1. Open Google Sheets in your browser.
  2. Click the tune / padlock icon situated at the far-left edge of Chrome’s address bar (just before docs.google.com).
  3. Click on Site settings.
  4. In the settings tab that opens, scroll to the Usage section at the top and click the button labelled Delete data (or Clear data).
  5. Confirm the prompt.
  6. Switch back to your Google Sheets tab and press F5 to reload.

Purging site-specific storage wipes corrupted local IndexedDB databases and forces Google Sheets to compile a fresh local cache.

Turn Off “Offline Sync” in Google Drive Settings

Google Drive’s offline access feature uses an internal database to mirror documents locally. If an offline sync conflict occurs, Sheets can get trapped trying to reconcile offline versions with the cloud.

  1. Navigate to drive.google.com in your browser.
  2. Click the Settings gear icon in the upper-right corner and select Settings.
  3. In the General tab, scroll down to the Offline section.
  4. Uncheck the box labelled Create, open and edit your recent Google Docs, Sheets, and Slides files on this device while offline.
  5. Reload your spreadsheet tab.

Disabling offline caching bypasses local database checks and connects your browser directly to the live cloud sheet.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.