'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for Mac Reporting Corrupt Files After Local Copying
Question details
Users are encountering an issue where older Excel workbooks open properly from an external drive but display a 'file corrupt' error after being copied to the Mac's local storage.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS Sonoma
- Scenario
- Copying older Excel files from an external hard drive to the local Mac drive and attempting to open the copied versions.
- Observed behavior
- The desktop Excel application displays a corruption error and refuses to open the local copy, even though the original file on the external drive remains readable.
Ensure you do not delete or modify the original working copies of your Excel files on the external drive until you have successfully opened and verified the local copies.
Use Excel for the Web to Create a Readable Local Copy
Upload the working file to Excel for the web and save a fresh copy to bypass the local macOS copying glitches.
This is the most reliable workaround. Excel for the web handles file reading differently than the desktop application. By opening the original file online and downloading a new copy, you force the system to generate a freshly encoded file that the desktop app can read without corruption errors.
Plug your external drive into your Mac and verify that the original Excel files are still accessible.
Open your web browser, navigate to Microsoft 365 online, and log in with your Microsoft account.
Use the 'Upload' button on the web interface to select and open the working Excel file directly from your external drive.
Once the file is open in your browser, click on the 'File' menu, select 'Save As', and click 'Download a Copy' to save a fresh version to your Mac's local drive.
Locate the newly downloaded file in your Mac's Finder, right-click, select 'Open With', and choose your Excel desktop application to verify it works.
Check File Permissions and Re-transfer
Verify that the local copy has the correct read/write permissions and try archiving the file before transferring to prevent data loss.
Use WPS Office to Seamlessly Open Excel Files on Mac
If Microsoft Excel for Mac continues to display corruption errors when copying files, consider switching to WPS Office. It provides excellent compatibility with all Microsoft Office file formats and often bypasses version-specific bugs found in Excel on macOS Sonoma, allowing you to access and edit your workbooks smoothly.
- 1. Install WPS Office for Mac: Download and install the free version of WPS Office specifically designed for macOS.
- 2. Open the Local File: Launch WPS Spreadsheets, click on 'Open', navigate to your local drive, and select the copied file that Excel reported as corrupt.
- 3. Save as a New Copy: Go to the 'Menu' > 'Save As', and save the file with a new name to ensure its structure is fully refreshed and accessible.
Frequently Asked Questions
Why does Excel for Mac report my file as corrupt only after copying it to my local drive?
This can happen due to macOS Sonoma Finder glitches, permission errors during the transfer from an external drive (especially ExFAT or NTFS formats), or minor metadata loss during the copy process, which causes Excel's strict security checks to misinterpret the file structure as damaged.
Can I recover my data if both the external and local copies start showing corruption errors?
Yes, you can try uploading the file to a cloud service like OneDrive or Google Drive, then opening it in the respective web version. Web applications often bypass strict desktop application security checks and can successfully extract the raw data.
Does the format of my external drive affect how Excel files are copied to a Mac?
Yes. Drives formatted as NTFS (Windows default) or certain ExFAT clusters can occasionally cause read/write anomalies on macOS. Ensure files are properly copied and the drive is safely ejected. Consider using APFS or Mac OS Extended formats if you strictly use Apple devices.
