Excel Slow to Open OneDrive or SharePoint Files: 3 Real Fixes

You double-click a file in your OneDrive folder. Excel sits there. Spinning cursor. Maybe 30 seconds. Maybe two minutes. Meanwhile the same file opened from a local D: drive is instant. What's actually happening here is that Excel isn't slow — the round-trip between Excel, the sync engine, and Microsoft's cloud endpoints is slow. You're feeling latency, not CPU load.

I've seen this on Surface Laptop 4s running Windows 11 23H2 with Microsoft 365 Apps 2405, and on older Windows 10 22H2 desktops with Office 2019. The trigger is almost always the same: something is doing a synchronous network check before the workbook renders. Let's walk through the three causes I see most, in order of how often they're the culprit.

Cause 1: AutoSave hammering the cloud on every open

AutoSave is the number one reason Excel feels sluggish on OneDrive. When it's enabled, Excel doesn't just open the file — it establishes a co-authoring session, subscribes to change notifications, and starts pushing deltas to the cloud. If your upload bandwidth is mediocre (anything under 10 Mbps up), or you're on a VPN backhauling traffic through a corporate data center, every open pays that tax.

The fix depends on whether you actually need co-authoring. If you're the only person who touches the file, turn AutoSave off. It's in the Quick Access Toolbar — the toggle in the top-left of the title bar. Click it so it goes grey. For a permanent fix across all workbooks, go to File > Options > Save and uncheck AutoSave files stored in the cloud by default in Excel.

If you do need co-authoring but the file lives on a slow connection, the real fix is to work on a local copy and use File > Save a Copy when you're done. Co-authoring is a real-time protocol; it was never designed for 4G tethered laptops.

One more thing: AutoSave also disables the ability to keep the file open without saving. If you're using AutoSave "just in case," you're paying a latency cost for a safety net that Ctrl+S already gives you for free.

Cause 2: Protected View scanning every cloud file

Files that arrive from the internet get opened in Protected View. That's by design — it's Excel's sandbox for untrusted content. The problem is that Microsoft's classification of "from the internet" includes anything synced through OneDrive or SharePoint, because the sync engine attaches a Zone.Identifier alternate data stream to mark the file's origin.

So Excel opens the file in Protected View, which means it has to spin up a separate sandboxed process, copy the file into the sandbox, and run it through the File Validation add-in. That's three extra steps before you see a single cell. On a 50 MB .xlsx with pivot caches, that's your 45-second wait.

You can confirm this is the cause by looking at the yellow bar at the top of the workbook. It'll say PROTECTED VIEW — Be careful, files from the internet can contain viruses. If you see that every time, this is your problem.

The fix is to trust the specific locations you actually use. Don't disable Protected View globally — that's a real security regression and one day it'll bite you. Instead, add your OneDrive and SharePoint roots as trusted locations:

File > Options > Trust Center > Trust Center Settings > Trusted Locations

Add new location:
  Path: C:\Users\<you>\OneDrive - <TenantName>
  Check: Subfolders of this location are also trusted

Add new location:
  Path: https://<tenant>.sharepoint.com/sites/<yoursite>
  Check: (network path — SharePoint URLs are supported here)

Restart Excel after adding these. The Protected View banner should stop appearing for files in those paths, and open time drops to what you'd expect from a local file.

Cause 3: The Office Document Cache is corrupted or bloated

Office keeps a local cache of cloud documents at %localappdata%\Microsoft\Office\16.0\OfficeFileCache. It exists so that files you've recently opened can be re-opened quickly and so unsynced changes survive a crash. In practice, this cache grows without bound, gets out of sync with what's actually on SharePoint, and starts causing Excel to hit the network repeatedly while it tries to reconcile.

You'll know this is your problem when opening a file fails or hangs, and then works fine after you reboot. The reboot clears the in-memory state of the cache, but the on-disk cache is still stale. Next open is slow again.

Close every Office app — Excel, Word, Outlook, Teams if it's using the Office cache — and then delete the cache contents:

%localappdata%\Microsoft\Office\16.0\OfficeFileCache

Delete everything inside that folder, not the folder itself. Restart Excel. The first open after this will be slow because the cache has to rebuild, but every open after that should be normal. If it isn't, you've got a different problem — usually antivirus real-time scanning every read from the cache directory.

Speaking of which: if you're running third-party AV like older Bitdefender or ESET builds, add the OfficeFileCache directory to its exclusion list. Defender is usually fine, but third-party AV hooks the filesystem filter driver and can add 200–500 ms to every file handle operation. On a workbook with dozens of linked sheets, that adds up.

Quick reference: which fix applies to you

One last note on Files On-Demand, since it shows up in the table: if a file shows a cloud icon in File Explorer, Excel has to trigger a download before it can open. On a large workbook, that's the entire open time. Right-clicking and choosing Always keep on this device forces the local copy to stay cached, and subsequent opens are instant. This is the cheapest fix on the list and it's worth doing for any file you open more than once a week.