Fix Excel Comments and Notes Missing in SharePoint Online
Question details
Users need to be able to view their Excel comments and notes when accessing files through a web browser on SharePoint Online.
- Product
- Microsoft Excel / SharePoint Online
- Device & OS
- not provided
- Scenario
- Viewing an Excel workbook stored in SharePoint Online or Microsoft Teams via a web browser.
- Observed behavior
- Comments and notes fail to appear when hovering over cells in the web version, even though they are clearly visible when the same file is opened in the Excel desktop application.
Ensure your web browser is fully updated and clear your browser cache, as outdated temporary internet files can sometimes interfere with interactive elements in web applications.
Adjust Cursor Position to View Comments
Excel for the web handles cursor interactions differently; you must hover over a specific part of the cell to view notes.
In the Excel desktop application, hovering anywhere over a cell with a note will usually display it. However, Excel for the web requires a more precise hover action.
Launch your web browser and open the affected Excel file in SharePoint Online or Excel for the web.
Find the specific cell that contains a note or comment. You will see a small colored triangle or indicator in the top-right corner of the cell.
Move your mouse pointer directly over the corner indicator rather than hovering over the center of the cell. The comment or note should now appear.
Troubleshoot Browser and Network Issues
Determine if browser extensions, cached data, or network firewall settings are blocking comments from displaying.
Isolate the Issue to the Specific File or Location
Verify if the missing comments issue is isolated to a single corrupted file or a specific Microsoft Teams storage location.
Use WPS Office for Reliable Excel File Viewing and Collaboration
If you frequently encounter display glitches and missing comments in Excel for the web, consider switching to WPS Office. It provides a highly compatible, robust desktop application experience for handling complex spreadsheets without the limitations of browser-based viewers.
- 1. Download and Install WPS Office: Visit the official WPS website, download the free version, and install it on your device.
- 2. Open your Excel file: Launch WPS Spreadsheet, click 'Open', and select your .xlsx file downloaded from SharePoint.
- 3. View comments effortlessly: Simply hover over any cell with a comment indicator to view the notes seamlessly.
Frequently Asked Questions
Why do Excel comments show on desktop but not in SharePoint Online?
Excel for the web handles mouse hover interactions differently than the desktop version. To view notes in the browser, you must hover precisely over the corner indicator of the cell, whereas the desktop app allows you to hover anywhere over the cell.
Can a corrupted workbook prevent comments from displaying in the web viewer?
Yes, localized corruption within a specific workbook can cause elements like comments, notes, or conditional formatting to disappear in the web view. Creating a new file and testing comments can help determine if the original file is damaged.
How do I view files shared in Microsoft Teams if comments are missing?
Files shared in Microsoft Teams group chats are actually stored in the sender's OneDrive. You can navigate to the 'Microsoft Teams Chat Files' folder in your OneDrive and open the Excel file directly from there to bypass potential Teams viewer issues.
