How to Keep Excel Comments Visible When Sharing Files via OneDrive
Question details
The user needs to prevent comments in older Excel workbooks from disappearing when shared with other users via OneDrive.

- Product
- Microsoft Excel, OneDrive
- Device & OS
- not provided
- Scenario
- Sharing older versions of Excel workbooks containing comments with multiple users through OneDrive.
- Observed behavior
- Comments in uploaded Excel files are initially visible but disappear when the shared file is subsequently opened by another user.
Verify that the comments are still present and visible in the original desktop Excel file before attempting to re-upload or adjust sharing settings.
Convert Older Workbooks to the Current .xlsx Format
Older Excel file formats (such as .xls from Excel 97-2003) can experience compatibility issues when viewed online. Converting the workbook to the modern .xlsx format ensures comments are preserved across platforms.
Compatibility differences between legacy Excel files and modern online viewers often cause specific elements, like comments, to hide or drop out. Updating the file format natively resolves this issue without requiring the recipient to purchase new software.
Launch the Excel desktop app and open the spreadsheet that is experiencing missing comments.
Navigate to 'File' > 'Info' from the top ribbon, and click on 'Convert' to update the file to the current .xlsx format.
Alternatively, click 'File' > 'Save As', choose your destination folder, click the 'Save as type' drop-down list, and select 'Excel Workbook (*.xlsx)'.

Share and Open via the Excel Web App
Having the recipient open the shared link directly in the Excel Web App avoids display issues caused by older or differing local Excel desktop versions.
Share and Collaborate Seamlessly with WPS Office
If you frequently encounter compatibility issues or missing comments due to differing Office versions, try WPS Office. It provides an excellent, free, and lightweight alternative to Microsoft Office that perfectly handles all modern and legacy Excel file formats without data loss.
- 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
- 2. Install the Software: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Open and Collaborate: Launch WPS Spreadsheet, open your existing Excel workbooks, and utilize the robust comment and cloud-sharing features.

Frequently Asked Questions
Why do my Excel comments disappear when viewed in OneDrive?
Comments often disappear if the workbook is saved in a legacy format (like Excel 97-2003 .xls) that experiences compatibility limitations with modern web viewers, or if the recipient downloads and opens the file in an outdated desktop version of Excel.
Can users with older versions of Excel open .xlsx files?
Users with much older versions of Excel may not be able to open .xlsx files directly unless they have installed the Microsoft Office Compatibility Pack. A simpler workaround is having them view the file online via the Excel Web App or using a free modern suite like WPS Office.
How can I share a workbook so everyone can see it without buying new software?
Save your workbook in the standard .xlsx format and share it via a OneDrive link. Recipients can simply click the link to view and edit the file directly in their web browser using the free Excel Web App, bypassing the need for updated desktop software.




