How to Fix OneDrive Excel Files Not Opening on a Mac
Question details
The user is unable to open specific Excel files stored in OneDrive on a Mac and receives a network unavailable error.

- Product
- Excel
- Device & OS
- Mac
- Scenario
- Attempting to open specific Excel files from a local Mac OneDrive folder.
- Observed behavior
- Excel displays a 'network is unavailable' error for certain files, while other files within the exact same OneDrive folder open normally.
Ensure your Mac is connected to a stable internet connection and that the OneDrive application is actively running and signed in on your Mac's menu bar.
Verify OneDrive Synchronization and Force Local Download
Use this method to ensure the affected Excel files are fully downloaded to your Mac's local storage instead of being cloud-only.
Often, files appear in the Mac Finder but are actually cloud-only placeholders. If the background sync process stalls, Excel will not be able to read the file data, resulting in a network error.
Click the OneDrive cloud icon in your Mac's top menu bar to verify that all files are currently up to date and that sync is not paused.
Open Finder, navigate to your OneDrive folder, and find the specific Excel file that is failing to open.
Right-click (or Control-click) the affected Excel file and select 'Always keep on this device' from the context menu.
Wait until the cloud icon next to the file name turns into a solid green circle with a checkmark, then double-click the file to open it in Excel.

Sign Out and Restart Microsoft Applications
Refreshing your account authentication tokens can resolve glitches where Excel fails to communicate securely with OneDrive.
Open via OneDrive Web and Restore Previous Version
If the file fails to open due to corruption after an update, opening it on the web allows you to check its integrity and restore a working version.
Edit Spreadsheets Locally and Seamlessly with WPS Office
If Excel and OneDrive synchronization issues persist on your Mac, WPS Office offers a highly compatible, lightweight, and completely free alternative for managing your spreadsheets without relying on Microsoft's cloud infrastructure.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free Mac version and complete the installation.
- 2. Open the affected file: Launch WPS Spreadsheets, click 'Open', and select your Excel file directly from the Mac Finder or OneDrive folder.
- 3. Save and edit effortlessly: Edit your document normally. WPS Office smoothly handles local files without triggering Microsoft's network errors.

Frequently Asked Questions
Why does Excel say the network is unavailable for only one specific file?
This usually happens when the specific file is stuck in a partial sync state, corrupted, or locked by a background process. While other files are safely stored on your Mac, Excel fails to fetch the incomplete data for the problematic file.
How can I stop OneDrive files from becoming cloud-only on my Mac?
You can disable the 'Files On-Demand' feature in your OneDrive app preferences. Open OneDrive Settings, navigate to the Preferences or Sync tab, and turn off Files On-Demand to ensure all files download locally.
Can I recover my Excel data if the file won't open at all?
Yes. The safest method is to log into OneDrive via your web browser, right-click the problematic file, select 'Version history', and restore an earlier iteration of the spreadsheet from before the syncing issue occurred.




