Fix Missing Excel Comments and Filters in Shared Workbooks (Mac/Windows)
Question details
Users need to restore missing comments and filters in an Excel workbook that is shared between Windows and Mac computers.
- Product
- Microsoft Excel
- Device & OS
- Windows and macOS
- Scenario
- Collaborating on a shared spreadsheet across different operating systems using a cloud storage platform like Dropbox.
- Observed behavior
- Comments and filters become completely unavailable or disappear when the workbook is opened on the Mac after being edited on Windows.
Before proceeding, locate a recent backup of the workbook that does not have the missing features to prevent permanent data loss during troubleshooting.
Restore from Backup and Reinstall Excel on Mac
Since file corruption and app glitches frequently cause feature drops across platforms, restoring a clean backup and reinstalling the Mac app often resolves the issue.
In many cases, cross-platform synchronization can corrupt the XML structure of an Excel file, rendering features like comments and filters unusable. A clean reinstallation of the Excel application on the Mac, combined with using a healthy backup file, clears any underlying cache or app configuration errors.
Find a backup copy or previous version of the workbook from before the comments and filters disappeared.
Open your Mac's Applications folder, locate Microsoft Excel, and drag it to the Trash to uninstall.
Restart your Mac to ensure all temporary system files and residual application caches are completely cleared.
Download and install the latest, fully updated version of Microsoft Excel from the Mac App Store.
Open the clean backup workbook in the newly installed Excel application to verify that the comments and filters are working normally.
Test Cross-Platform Compatibility with a New Workbook
Isolate whether the problem is tied to the specific corrupted file or the cloud storage service by testing a brand new file on an alternative service like OneDrive.
Use WPS Office for Reliable Cross-Platform Spreadsheet Sharing
Avoid version conflicts and corrupted files when sharing spreadsheets between Mac and Windows. WPS Office is a free, lightweight alternative that offers excellent cross-platform compatibility and feature stability.
- 1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on both your Mac and Windows computers.
- 2. Sign in to WPS Cloud: Create or log in to your WPS account to enable built-in cloud synchronization across your devices.
- 3. Open your spreadsheets seamlessly: Open your existing .xlsx files directly in WPS Spreadsheet. Your data, comments, and filters will be fully supported and stable.
Frequently Asked Questions
Why do Excel comments disappear when opening files on a Mac?
This usually happens due to file corruption during cross-platform syncing or when using an outdated version of Excel on Mac that does not support newer threaded comments created on a Windows PC.
Can cloud storage services like Dropbox cause Excel filters to stop working?
While cloud storage rarely breaks specific features, synchronization conflicts can occasionally corrupt a workbook's underlying XML structure. This corruption manifests as missing features, such as broken filters or missing comments.
How do I recover a corrupted Excel file on Mac?
You can attempt recovery by opening the file using the 'Open and Repair' feature in Excel for Windows, restoring a previous version from your cloud storage version history, or retrieving a healthy copy from Time Machine on your Mac.
