Troubleshooting “Slow Cloud Save” and “Pending Upload” loops.

A “Slow Cloud Save” or indefinite “Pending Upload” loop occurs when Excel cannot complete the synchronization handshake with OneDrive or SharePoint. Instead of instantly saving incremental changes, the status bar displays a continuous spinning circle, “Saving…”, or “Upload Pending.” This issue is caused by local Office cache corruption, conflicts between Excel and the OneDrive sync client, or oversized background calculations.

Quick Fix

Save an immediate local backup by selecting File > Save a Copy to your local drive. Then, clear the pending upload: right-click the OneDrive cloud icon in the Windows system tray, select Pause syncing for 2 hours, wait ten seconds, and click Resume syncing.

---

Step 1: Clear the Office Document Cache

The most common reason an upload hangs is that the local Office Document Cache has stalled. Excel uses this hidden cache to hold edits before streaming them to SharePoint or OneDrive. If a temporary file in the cache becomes locked, all subsequent saves queue up behind it.

1. Close all active Office applications (Excel, Word, PowerPoint).
2. Open Excel to a blank workbook.
3. Click File > Options.
4. Select the Save category in the left sidebar.
5. Scroll down to Cache Settings.
6. Check the box for “Delete files from the Office Document Cache when they are closed”.
7. Click the Delete cached files button.
8. When prompted, confirm deletion.
9. Close Excel and reopen your cloud workbook.

If the file continues to show authentication warnings or upload failures after clearing the cache, follow the remediation steps in How to fix “Upload Blocked” and “Sign in required” for OneDrive/SharePoint files..

---

Step 2: Resolve Local OneDrive Sync Client Deadlocks

Excel has its own built-in synchronization engine that works directly with the local OneDrive sync client. If both applications attempt to lock and process the same file at the same time, an upload deadlock can occur.

Verify File Collaboration Settings:

1. Click the OneDrive cloud icon near the Windows taskbar clock.
2. Select the Gear icon (Settings) > Settings.
3. In the settings window, locate the Sync and backup tab and expand Advanced settings.
4. Check the status of File collaboration (or “Use Office applications to sync Office files that I open”).
5. If the toggle is active and you are experiencing chronic upload hangs, turn it Off, wait ten seconds, and turn it back On. This restarts the file-streaming hook between Excel and the OneDrive background service.

If OneDrive reports that your file cannot be reconciled with the version in the cloud, consult Fixing “File was not uploaded because changes cannot be merged” in OneDrive..

---

Step 3: Eliminate Spreadsheet Bloat and Calculation Overhead

Cloud saving uses differential syncing: it sends only the parts of the workbook that changed. If a spreadsheet contains thousands of volatile formulas or bloated, uncleaned ranges, Excel has to recalculate and repackage the entire file before uploading even a minor edit.

Diagnostic Checks inside the Workbook:

• Excessive Used Range:
  Press Ctrl + End on each worksheet. If your cursor stops at row 1,048,576 or column XFD, but your actual data ends at row 500, Excel is packaging millions of empty, formatted cells into the cloud payload. Delete the empty rows and columns, then save.
• Volatile Formulas:
  Formulas like OFFSET, INDIRECT, TODAY(), and NOW() force a complete recalculation of dependent chains across the workbook upon every keystroke. To understand how to diagnose and restructure these heavy formulas, see The Volatile Function Bloat: How INDIRECT and OFFSET kill system performance..
• Ghost Locks:
  If another user left a session active that created an orphaned lock on the SharePoint library, Excel will wait to save until the server clears that lock. To identify and handle orphaned owner locks, read “The file is locked for editing”: How to kill “Ghost” owner files (~$filename)..

---

Step 4: Network and Proxy Configuration Checks

In corporate networks, strict firewalls and proxy servers can interrupt the continuous HTTPS streaming connections required by Microsoft 365 co-authoring.

1. Check VPN/Proxy Traffic:
   If you are connected to a corporate VPN, disconnect temporarily (if security policy permits) and test saving over standard broadband. If the save completes immediately, the VPN’s deep packet inspection is dropping long-lived WebDAV or REST API packets.
2. Review Upload Bandwidth:
   In OneDrive Settings, check Sync and backup > Advanced settings > Download and upload rate limits. Ensure that upload throughput is set to Don’t limit rather than an artificially capped transfer speed.

---

Summary Checklist

• Create a local copy via File > Save a Copy to protect unsaved work before troubleshooting.
• Clear the local document cache via File > Options > Save > Delete cached files.
• Pause and resume OneDrive syncing to reset stalled background pipelines.
• Press Ctrl + End to locate and remove bloated, unused cell ranges.
• Confirm corporate VPN or proxy software is not severing long-lived HTTPS synchronization streams.