Fix Excel Comment Authors and Removed @Mentions in SharePoint
Question details
The user needs to preserve comment authors and @mentions in an Excel workbook stored in SharePoint Online.

- Product
- Microsoft Excel and SharePoint Online
- Device & OS
- not provided
- Scenario
- Comments are created in desktop Excel and Excel for the web in a SharePoint-hosted workbook.
- Observed behavior
- Original author names appear as Author, and @mentions display as removed.
Confirm that the workbook is stored in SharePoint Online and identify the template used to create it. Check whether a new workbook in the same SharePoint folder preserves comment names and @mentions.
Check the workbook and template privacy settings
Use this approach when the affected workbook or its template may be removing personal information.
In the same SharePoint folder, create a new Excel workbook and add a comment with an @mention. Check whether the author and mention remain after saving and reopening it.
Open the affected workbook in desktop Excel and go to File > Options > Trust Center > Trust Center Settings > Privacy Options. If Remove personal information from file properties on save is available and selected, clear it and save the workbook.
Open the Excel template used to create the workbook and check the same Privacy Options setting. If it is enabled, turn it off and save the template, then create a test workbook from it.
Add a comment and @mention in the test workbook, save it to SharePoint, and reopen it in Excel to check whether both are retained.

Check SharePoint access and workbook version history
Use this when the privacy setting does not explain the issue or you need to look for an earlier version of the comments.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheet files. Open compatible Excel workbooks in WPS Spreadsheets for an easy transition; it does not fix SharePoint's Microsoft Excel comment or @mention behavior.

Frequently Asked Questions
Why do comments show Author instead of the person's name?
A workbook or template may be set to remove personal information when saved. In desktop Excel, check File > Options > Trust Center > Trust Center Settings > Privacy Options for the relevant setting.
How can I tell whether the template is causing the problem?
Create a blank workbook in the same SharePoint folder and test a comment and @mention. Then create another workbook from the original template and repeat the test. A difference between the two points to the template as a useful place to investigate.
Can I recover comment names that have already been removed?
Changing the privacy setting may not restore removed information. In the SharePoint document library, open the workbook's Version history and check an earlier version for the original comments.
Where can I check who has access to the workbook?
Select the workbook in the SharePoint document library and open Manage access. If an account or its access is unclear, ask a SharePoint administrator to review it.




