Excel Freezing or “Not Responding” When Opening Files from OneDrive – Files On-Demand Root Cause & Fix
🔍 The Symptoms / Error Message
⚠️ What You May Experience
- Microsoft Excel becomes unresponsive when opening certain files
- Excel displays “Not Responding” and freezes during file open
- Files sometimes open, but most of the time fail when accessed locally via OneDrive sync
- The same files open successfully via OneDrive Web (Office Online)
🧠 Root Cause
💡 Why This Happens
The issue is caused by OneDrive Files On-Demand, where files appear locally on the device but are not fully downloaded (“hydrated”).
- Excel requires full local file access to open a workbook
- If the file is still cloud-only or partially synced, Excel may hang or freeze during retrieval
- Network latency or incomplete sync can worsen the problem
This behaviour is more noticeable with large Excel files, files with complex formulas, macros, or external data connections.
🛠️ Step-by-Step Resolution
Ensure Files Are Fully Downloaded — Recommended Fix
Force the file to download completely to the local device before opening it in Excel.
📋 Steps
- Navigate to the affected file or folder in File Explorer
- Right-click on the file (or folder)
- Select “Always keep on this device”
- Wait for the sync status icon to change to a solid green checkmark ✅
This ensures the file is fully downloaded (hydrated) and Excel accesses it locally without any delay or network dependency.
Disable Files On-Demand — If Issue Is Frequent
Use this if multiple users are impacted or regularly working with large Excel files.
📋 Steps
- Click the OneDrive icon in the system tray
- Go to Settings
- Select the Sync and backup tab
- Disable: “Save space and download files as you use them” (Files On-Demand)
- Restart OneDrive
⚠️ Note
Disabling Files On-Demand means all synced files will be fully downloaded to the device. Ensure sufficient local disk space is available before doing this at scale.
Force Sync OneDrive
If a file appears stuck in a partial sync state, resetting the sync can resolve it.
📋 Steps
- Right-click the OneDrive system tray icon
- Click Pause syncing → then Resume syncing
- Or restart OneDrive completely using Run (Win + R):
%localappdata%\Microsoft\OneDrive\OneDrive.exe /restart
✅ Administrative Validation via PowerShell
While there is no direct PowerShell command to hydrate specific files, admins can verify OneDrive/SharePoint configuration and confirm sync health.
Connect-SPOService -Url https://<your-tenant>-admin.sharepoint.com
Get-SPOSite -IncludePersonalSite $true -Limit All | Where-Object {$_.Url -like "*-my.sharepoint.com/personal/*"}
📋 OneDrive Log Collection — User-Level Troubleshooting
Guide users to collect OneDrive sync logs from the following path for deeper diagnostics:
%localappdata%\Microsoft\OneDrive\logs
💡 Best Practices & Recommendations
- Use “Always keep on this device” for critical or frequently accessed Excel files
- Ensure the OneDrive client is updated regularly to get sync stability fixes
- Avoid working directly on large files in a partially synced state
- For enterprise users, consider disabling Files On-Demand for high-impact teams such as Finance and Reporting
✅ Key Takeaway
If Excel files freeze when opened locally but work fine in the browser, always check whether the file is fully downloaded. OneDrive Files On-Demand is useful for saving disk space, but when Excel needs immediate full file access, ensuring complete local availability resolves the issue instantly.
📚 References & Further Reading
- 🔗 Excel keeps freezing when opening shared files from OneDrive — Microsoft Learn Q&A