Fix Excel for Mac Missing Features: @Mentions, LAMBDA, and Power Query
Question details
User needs help understanding and resolving the missing or limited functionality of @mentions, LAMBDA functions, and Power Query in Microsoft 365 Family on Mac.
- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Trying to use advanced collaboration tools and data analysis functions in Excel for Mac.
- Observed behavior
- @Mentions fail to tag users properly, the LAMBDA function is unavailable, and Power Query lacks the full editor interface compared to the Windows version.
Ensure your Mac is connected to the internet and verify your exact Microsoft 365 subscription type, as advanced feature availability on macOS heavily depends on whether you are using a Family, Work, or School account.
Resolve @Mentions and Collaboration Limitations
Use this solution to understand the account and storage requirements necessary for @mentions to work in Excel for Mac.
In Microsoft Office, the @mentions feature is designed primarily for enterprise environments. It typically requires a Work or School account and specific cloud storage configurations. Microsoft 365 Family editions may experience inconsistent or disabled @mention functionality.
Check if you are signed in with a Microsoft 365 Family account. For reliable @mentions, a Work or School account is generally required.
Ensure the Excel file is saved in OneDrive for Business or SharePoint, as @mentions will not function reliably on local storage or personal OneDrive accounts.
Verify that the people you are trying to @mention belong to the same business domain or organization tenant as your account.
Enable the LAMBDA Function on Mac
Update your Excel build or join the Office Insider Beta Channel to access the newer LAMBDA function.
Work with Power Query on Mac
Learn how to manage Power Query data on a Mac despite the absence of the full Power Query Editor.
Try WPS Office for a Seamless Mac Spreadsheet Experience
If you are frustrated by the feature limitations, update channels, and account restrictions in Microsoft 365 for Mac, WPS Office provides a lightweight, highly compatible, and feature-rich alternative for macOS users. Enjoy powerful data analysis and collaboration without complex license barriers.
- 1. Download WPS Office: Visit the official WPS website and download the macOS version.
- 2. Install the application: Open the downloaded file and drag the WPS Office icon into your Applications folder.
- 3. Open your spreadsheets: Launch WPS Office and open your Excel files directly to continue your work without feature lockouts.
Frequently Asked Questions
Why can't I use @mentions in Excel with my Microsoft 365 Family account?
@Mentions generally require a Microsoft 365 Work or School account to function correctly. Furthermore, the file must be stored on a compatible cloud service like OneDrive for Business or SharePoint, and the tagged users usually need to be within the same organizational tenant.
Will the full Power Query Editor ever be available on Excel for Mac?
Microsoft has been gradually rolling out Power Query features to Excel for Mac over time. While you can currently refresh existing queries and perform basic data imports, the full advanced Power Query Editor available on Windows is still not fully mirrored on the Mac version.
How do I get the LAMBDA function on my Mac if it is missing?
If you do not see the LAMBDA function, your Excel build may not be updated to a version that supports it. You can access it by going to Help > Check for Updates, opting into the Office Insider Beta Channel, and updating to the newest available build.
