SharePoint Document Issues

Fix Excel Comment Authors and Removed @Mentions in SharePoint

Olivia MillerOlivia Miller Nov 14, 2026 869 views

Question details

The user needs to preserve comment authors and @mentions in an Excel workbook stored in SharePoint Online.

Fix Excel Comment Authors and Removed @Mentions in SharePoint
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.
Before you start

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.

Solution 1Recommended

Check the workbook and template privacy settings

Use this approach when the affected workbook or its template may be removing personal information.

1
Compare with a new workbook

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.

2
Review the privacy option

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.

3
Inspect the template

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.

4
Test a new comment

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 the workbook and template privacy settings
Previously removed information: Changing the privacy setting may prevent further removal, but it may not restore names or mentions already removed from existing comments. The option's availability can vary by Excel version and workbook.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet content and comments in WPS SpreadsheetsUse a familiar interface when moving from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.