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 you resolve the issue and regain access to your spreadsheets.

Quick Fix Steps

1. Close Microsoft Excel completely.
2. Restart your computer to clear any temporary file locks.
3. Check your internet connection to ensure OneDrive or SharePoint can sync.
4. 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.

1. Look for the OneDrive cloud icon in the Windows taskbar notification area (bottom-right corner).
2. If you see a red "X" or a sync error, select the icon and follow the prompts to resolve the issue.
3. Wait until the status shows Up to date before opening your Excel file.

2. Open the File from the Web

Opening the file in Excel for the web can bypass local sync issues.

1. Go to onedrive.live.com or your SharePoint site in Microsoft Edge or Google Chrome.
2. Sign in with your Microsoft 365 account.
3. Navigate to the file and select it to open in Excel for the web.
4. If the file opens successfully, select Edit in Browser or Open in Desktop App.

3. Repair Microsoft Office

Corrupted Office installation files can cause Excel to freeze.

1. Select the Start button and type Control Panel, then press Enter.
2. Select Programs > Programs and Features.
3. Find Microsoft 365 or Microsoft Office in the list.
4. Right-click it and select Change.
5. Select Quick Repair and follow the prompts. If the issue continues, repeat these steps and choose Online Repair.

4. Disable Hardware Graphics Acceleration

Graphics acceleration can sometimes cause Excel to stop responding. If Excel will not open, skip to the next step.

1. Open Excel and select File > Options.
2. Select Advanced from the left menu.
3. Scroll down to the Display section.
4. Tick the box for Disable hardware graphics acceleration.
5. Select OK and restart Excel.

5. Clear the Office Document Cache

Clearing the cache can resolve conflicts with files stored in OneDrive or SharePoint.

1. Close all Office applications.
2. Press Windows Key + R to open the Run dialog.
3. Type %localappdata%\Microsoft\Office\16.0\OfficeFileCache and press Enter.
4. Delete the contents of this folder.
5. Restart Excel and try opening the file again.

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.

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

• Troubleshooting Excel Sync Issues with OneDrive and SharePoint
• Installing and Activating Microsoft 365 Apps
• Repairing Microsoft Office Applications

Still Having Issues?