Permission & Access Issues

Fix Excel @Mentions Not Working in SharePoint vs OneDrive

John WilsonJohn Wilson Oct 21, 2026 869 views

Question details

The user is experiencing inconsistent availability of the @Mention feature in Excel comments depending on whether the file is hosted in a personal OneDrive or SharePoint/Teams.

Why Excel @Mentions Differ Between OneDrive and SharePoint
Product
Microsoft Excel, SharePoint, OneDrive
Device & OS
not provided
Scenario
Collaborating on Excel files stored in SharePoint or Microsoft Teams using view-only or restricted access links.
Observed behavior
The @Mention feature works normally for files in personal OneDrive but is disabled or unavailable for files stored in SharePoint or Teams when users have view-only access.
Before you start

Ensure you are using Excel for the web, as advanced collaboration features like @mentions and specific review permissions are best supported and updated most frequently in the online browser version.

Solution 1Recommended

Configure SharePoint Sharing Permissions to 'Can review'

Change the file permission in SharePoint from 'View-only' to 'Can review' to allow users to utilize the @mention feature.

SharePoint and personal OneDrive handle file permissions differently. In SharePoint and Teams, a standard 'View-only' permission strictly prevents users from leaving comments or using @mentions.

To enable mentions without giving full editing access, the file must be explicitly shared using the 'Can review' permission.

1
Access the Document Library

Open your SharePoint document library or the Microsoft Teams 'Files' tab where the Excel spreadsheet is stored.

2
Open Sharing Options

Select the Excel file you want to share, click the three dots (More options) next to the file name, and select 'Share'.

3
Modify Permission Settings

In the sharing dialog box, click on the current permission level (which usually defaults to 'Can edit' or 'Can view') to open the permission settings.

4
Select 'Can review'

Choose the 'Can review' option from the drop-down menu. This allows users to read the document and leave comments or mentions without modifying the actual spreadsheet data.

5
Apply and Share

Click 'Apply' and copy the link to share it with your team members.

Configure SharePoint Sharing Permissions to 'Can review'
Use Excel for the Web: Ensure your collaborators open the shared file using Excel for the web, as the 'Can review' permission operates seamlessly in the browser environment.
Free Microsoft Office alternative

Experience Seamless Collaboration with WPS Office

If you are tired of complex permission settings and inconsistent collaboration features across different cloud platforms, try WPS Office. It's a free, lightweight, and highly compatible alternative to Microsoft Office that simplifies document sharing and team collaboration.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your PC, Mac, or mobile device.
  2. 2. Open Your Spreadsheets: Open your existing .xlsx files directly in WPS Spreadsheet without losing any formatting or data.
  3. 3. Collaborate Easily: Use WPS Cloud to share files with simple, straightforward permission settings that are easy for your entire team to understand.
Fully compatible with Microsoft Excel (.xlsx) and other Office formatsLightweight installation with a familiar, easy-to-use interfaceSeamless cloud integration for smooth team collaboration without permission headachesBuilt-in commenting and review tools that work identically across desktop and web
microsoft office alternative - wps office

Frequently Asked Questions

Why do @mentions work in my personal OneDrive but not in Teams?

Personal OneDrive often grants broader default editing rights when sharing files, whereas Teams and SharePoint use stricter organizational permissions. If a file in Teams is shared as 'View-only', the @mention feature is intentionally disabled.

Can I use @mentions in the desktop version of Excel?

Yes, if you have an active Microsoft 365 subscription. However, when using the specialized 'Can review' permission from SharePoint, it is highly recommended to use Excel for the web for the best compatibility and real-time syncing.

What exactly does the 'Can review' permission do?

The 'Can review' permission allows users to read the document and interact via comments or mentions, but restricts them from making direct edits to the core data of the spreadsheet.

What happens if I mention someone who doesn't have access to the SharePoint file?

Excel will usually prompt you to grant them access when you post the comment. If you don't have the administrative rights to share the file, the @mention will not send an email notification or grant them access.