Fix Excel for Mac Crashing When Opening Workbooks from OneDrive or SharePoint
Question details
Excel for Mac crashes with an EXC_BAD_INSTRUCTION error when opening a specific workbook stored in a OneDrive or SharePoint folder.
- Product
- Microsoft Excel for Mac, OneDrive, SharePoint
- Device & OS
- Mac
- Scenario
- Opening a synchronized shared workbook directly from a SharePoint subfolder via OneDrive.
- Observed behavior
- The Excel application crashes immediately, displaying an EXC_BAD_INSTRUCTION error. Copying the exact same workbook to the local desktop bypasses the crash, but the file still runs slowly.
Ensure you have the latest updates installed for both Microsoft Excel for Mac and the OneDrive sync client, as outdated software can cause severe synchronization conflicts.
Copy the Workbook Locally and Optimize File Features
Moving the file to your local drive prevents synchronization conflicts, allowing you to safely review and disable complex elements like slicers and external links that trigger the crash.
Workbooks with heavy external links, complex macros, or extensive slicers can sometimes fail to process correctly when opened directly through a cloud-sync client like OneDrive. Isolating the file locally helps rule out server-side locks.
Copy the problematic workbook from your OneDrive or SharePoint synchronized folder and paste it onto your Mac's Desktop.
Open the local copy in Excel. Go to the 'Formulas' tab on the ribbon and temporarily set 'Calculation Options' to 'Manual'.
Review the workbook and remove any unnecessary or complex slicers, macros, or broken external links that might be hindering performance.
Save the optimized workbook with a new file name. Move the newly saved file back to your OneDrive or SharePoint folder and attempt to open it again.
Check OneDrive Synchronization Status
Verify that the OneDrive client is not stuck or locking the file during synchronization.
Try WPS Office for Stable Spreadsheet Editing on Mac
If Excel for Mac continues to crash when opening cloud-synced workbooks, consider switching to WPS Office. It provides a lightweight, highly stable environment for editing spreadsheets without synchronization conflicts, while remaining fully compatible with Microsoft Office formats.
- 1. Download WPS Office: Download and install the free version of WPS Office for Mac from the official website.
- 2. Open Spreadsheets: Launch WPS Spreadsheets and click on the 'Open' button on the homepage.
- 3. Select the Workbook: Navigate to your local OneDrive or SharePoint folder and open the workbook smoothly.
Frequently Asked Questions
Why does my Excel file open on the desktop but crash from OneDrive?
This happens when the crash is triggered by a synchronization conflict or a file-locking issue on the server. When the file is on the desktop, Excel does not have to negotiate with the OneDrive sync client or SharePoint server, bypassing the software bug causing the crash.
What does the EXC_BAD_INSTRUCTION error mean in Excel for Mac?
EXC_BAD_INSTRUCTION is a low-level application crash on macOS indicating that Excel attempted to execute an invalid, corrupt, or unsupported process. In this context, it is usually triggered by memory issues or bugs when interacting with complex spreadsheet elements via cloud storage paths.
How can I fix a slow Excel workbook on my Mac?
To improve workbook performance, try turning off automatic calculations, breaking unnecessary external links, removing unused conditional formatting, and clearing out complex slicers or macros. Keeping your software updated also ensures performance patches are applied.
