How to Fix Microsoft Excel Not Responding When Opening Files from OneDrive or SharePoint
Summary
This guide helps you troubleshoot and resolve: How to Fix Microsoft Excel Not Responding When Opening Files from OneDrive or SharePoint. Follow the steps below to fix the issue.
Common Causes
How to Fix Microsoft Excel Not Responding When Opening Files from OneDrive or SharePoint
Microsoft Excel may stop responding or freeze when opening files stored in OneDrive or SharePoint due to sync conflicts, outdated Office versions, or issues with the Office Upload Centre. This guide provides steps to help Australian small businesses resolve the issue and regain access to important spreadsheets, including BAS and GST documents.
Determine if the Issue Affects One User or Multiple Users
Before troubleshooting, establish whether the problem is isolated to a single computer or affecting multiple staff members. This helps identify if the cause is a local installation issue or a broader SharePoint or OneDrive service problem.
- Ask colleagues in your business if they experience the same freezing when opening the same file.
- Try opening the file from a different computer signed into the same Microsoft 365 account.
- If multiple users are affected, check the Microsoft 365 Service Health dashboard for known OneDrive or SharePoint outages in the Australian region.
- If only one user is affected, proceed with the troubleshooting steps below on that computer.
Quick Fix Steps
- Close Microsoft Excel completely. If it is unresponsive, press
Ctrl + Shift + Escto open Task Manager, select Excel, and choose End task. - Restart your computer to clear any temporary file locks.
- Check your internet connection to ensure OneDrive or SharePoint can sync.
- Try opening the file directly from the OneDrive or SharePoint website in your browser.
Detailed Instructions
1. Check OneDrive Sync Status
Ensure OneDrive is running and syncing correctly before opening Excel files.
- Look for the OneDrive cloud icon in the Windows taskbar notification area (bottom-right corner). You may need to select the up-arrow to show hidden icons.
- If you see a red "X" or a sync error, select the icon and follow the prompts to resolve the issue.
- Wait until the status shows Up to date before opening your Excel file.
- Check if Files On-Demand is enabled. Right-click the OneDrive icon, select Help & Settings > Settings, and confirm that Save space and download files as you use them is ticked if you wish to use on-demand files. Large spreadsheets may perform better when set to Always keep on this device.
2. Open the File from the Web
Opening the file in Excel for the web can bypass local sync issues.
- Go to
onedrive.live.comor your SharePoint site in Microsoft Edge or Google Chrome. - Sign in with your Microsoft 365 account.
- Navigate to the file and select it to open in Excel for the web.
- If the file opens successfully, select Edit in Browser or Open in Desktop App.
3. Check for Office Updates
Outdated Office versions can cause compatibility issues with OneDrive and SharePoint.
- Open Excel and select File > Account.
- Under Product Information, select Update Options.
- Choose Update Now.
- If updates are unavailable, check whether your business uses the Microsoft Store version of Office. Open the Microsoft Store, select Library, and choose Get updates.
- Restart Excel after installing updates.
4. Repair Microsoft Office
Corrupted Office installation files can cause Excel to freeze.
- Select the Start button and type
Control Panel, then pressEnter. - Select Programs > Programs and Features.
- Find Microsoft 365 or Microsoft Office in the list.
- Right-click it and select Change.
- Select Quick Repair and follow the prompts. If the issue continues, repeat these steps and choose Online Repair.
5. Disable Hardware Graphics Acceleration
Graphics acceleration can sometimes cause Excel to stop responding. If Excel will not open, skip to the next step.
- Open Excel and select File > Options.
- Select Advanced from the left menu.
- Scroll down to the Display section.
- Tick the box for Disable hardware graphics acceleration.
- Select OK and restart Excel.
6. Clear the Office Document Cache
Clearing the cache can resolve conflicts with files stored in OneDrive or SharePoint. The cache path may vary depending on your Office installation.
- Close all Office applications.
- Press
Windows Key + Rto open the Run dialog. - Type
%localappdata%\Microsoft\Office\and pressEnter. - Look for version folders such as
16.0. If multiple version folders exist, check each one. - Open the
OfficeFileCachefolder inside the relevant version folder. You may need to enable Hidden items in File Explorer to see this folder. - Delete the contents of the
OfficeFileCachefolder. - Restart Excel and try opening the file again.
7. Check for Conflicting Antivirus Software
Third-party antivirus software scanning OneDrive or SharePoint folders in real-time can cause Excel to freeze when opening files.
- Open your antivirus programme.
- Locate the real-time scanning or file shield exclusions settings.
- Add exclusions for your OneDrive and SharePoint sync folders, typically located in
%userprofile%\OneDriveand your SharePoint synced library path. - Temporarily disable real-time scanning to test if Excel opens the file normally, then re-enable it and configure the exclusion permanently.
8. Check SharePoint File Size and Type Restrictions
SharePoint has limits on file size and certain blocked file types that may cause sync or opening issues.
- Confirm the file size is within SharePoint limits (currently up to 250 GB per file, though performance may degrade with very large spreadsheets).
- Ensure the file extension is not blocked by your organisation's SharePoint policy.
- Check that the file path length does not exceed SharePoint limits, including the folder name and file name combined.
Troubleshooting
Excel Freezes on Specific Files Only
If only one file causes Excel to stop responding, the file may be corrupted.
- Open Excel and select File > Open.
- Select Browse and navigate to the file.
- Click the arrow next to the Open button and select Open and Repair.
- Choose Repair to recover as much data as possible.
Run Excel in Safe Mode to Check for Add-in Conflicts
Third-party add-ins can conflict with OneDrive or SharePoint integration.
- Close Excel completely.
- Press
Windows Key + R, typeexcel /safe, and pressEnter. - Try opening the file from OneDrive or SharePoint.
- If Excel opens the file successfully in Safe Mode, an add-in is likely causing the issue.
- Exit Safe Mode, open Excel normally, and select File > Options > Add-ins.
- At the bottom, select COM Add-ins from the dropdown and choose Go.
- Untick add-ins one by one, restarting Excel after each change, to identify the conflicting add-in.
OneDrive Shows "Processing Changes" for a Long Time
A large file or many simultaneous edits can cause OneDrive to stall.
- Pause OneDrive syncing by selecting the OneDrive icon in the taskbar, then Help & Settings > Pause syncing.
- Wait a few minutes, then resume syncing.
- Check the OneDrive website to see if the latest version of the file has uploaded.
If you have tried these steps and Excel still stops responding when opening OneDrive or SharePoint files, please Open a Ticket with our support team for further assistance.
Related Articles
Still Having Issues?
💻 Open a Ticket