File Sharing Problems

How to Keep Excel Comments Visible When Sharing Files via OneDrive

Aamir Naveed AkramAamir Naveed Akram Nov 4, 2026 870 views

Question details

The user needs to prevent comments in older Excel workbooks from disappearing when shared with other users via OneDrive.

How to Keep Excel Comments Visible When Sharing 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.
Before you start

Verify that the comments are still present and visible in the original desktop Excel file before attempting to re-upload or adjust sharing settings.

Solution 1Recommended

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.

1
Open the Workbook

Launch the Excel desktop app and open the spreadsheet that is experiencing missing comments.

2
Convert via Info Menu

Navigate to 'File' > 'Info' from the top ribbon, and click on 'Convert' to update the file to the current .xlsx format.

3
Convert via Save As

Alternatively, click 'File' > 'Save As', choose your destination folder, click the 'Save as type' drop-down list, and select 'Excel Workbook (*.xlsx)'.

Convert Older Workbooks to the Current .xlsx Format
Format Updated: Saving your file in the .xlsx format maximizes compatibility across different versions of Excel and ensures web viewers display all elements properly.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free installer for your operating system.
  2. 2. Install the Software: Run the setup file and follow the straightforward on-screen instructions to complete the installation.
  3. 3. Open and Collaborate: Launch WPS Spreadsheet, open your existing Excel workbooks, and utilize the robust comment and cloud-sharing features.
Fully compatible with Microsoft Excel formats, including legacy .xls and modern .xlsx files.Free and lightweight suite available for Windows, Mac, Linux, and mobile devices.Familiar user interface ensures a seamless migration with zero learning curve.Built-in cloud and sharing tools make collaboration across devices effortless.
microsoft office alternative - wps office

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.