Updated November 18, 2025: New capabilities are now available for Frontier program customers. We have updated the content below to provide additional details on how to use Agent Mode in Copilot in Excel.
[Introduction:]
Agent Mode in Microsoft 365 Copilot for Excel, available now on the web and Windows desktop, is a new way for users to work with Copilot in Excel. It uses natural language to build and edit workbooks and allows users to keep their content editable and stay up to date with the latest changes. Agent mode can search the web to pull in trusted, up-to-date information from the internet to complement your Excel data. It helps answer questions, provide context, and enrich your analysis without leaving your workbook. Agent Mode in Excel also supports working with Claude AI models from Anthropic to build workbooks directly in Excel.
Users stay in control over all modifications at any time. To learn more, read https://aka.ms/Agent_Mode.
[How to access Agent Mode in Copilot in Excel:]
- Available to Microsoft Frontier program customers starting October 21, 2025.
- For Enterprise Microsoft 365 Copilot license customers, admins need to enable Frontier access for their organization in the Microsoft 365 Admin Center.
- For Microsoft 365 Personal, Family or Premium licenses, customers can turn on Frontier Features with a new toggle under the Copilot ribbon button.
- Once Frontier features are turned on, customers will see a new Agent Mode option under the Tools menu in Copilot chat.
- This version will soon include more features and support for additional languages.
[What you can do to prepare:]
- Ensure Frontier Features are enabled in your tenant.
- Admins must allow access to Anthropic AI models by allowing ‘AI providers for other large language models’ in the Microsoft 365 Admin Center before users can access Claude with Agent Mode in Excel.
- Alternatively, ensure Office add-ins are enabled in your tenant and enable use of the Excel Labs add-in. To learn more, see Review and manage add-ins in the admin center.
- Review documentation here: Use Claude with Agent Mode in Excel
[Compliance considerations:]
No compliance considerations identified, review as appropriate for your organization.
Source: Microsoft
<<< [MC1162083] Archive
Tooltip: View earlier revisions of this post
Latest Posts
- Microsoft OneNote: Copilot notebook available in OneNote on Mac [MC1409042]
![Microsoft OneNote: Copilot notebook available in OneNote on Mac [MC1409042] 1 pexels yankrukov 8866797](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- (Updated) Microsoft Teams: Proximity join support for presenters in Teams events from Teams Rooms on Windows and Android [MC1319213]
![(Updated) Microsoft Teams: Proximity join support for presenters in Teams events from Teams Rooms on Windows and Android [MC1319213] 2 pexels divinetechygirl 1181248](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- (Updated) Microsoft Teams Town halls: Upload custom backgrounds in Manage what attendees see [MC1307982]
![(Updated) Microsoft Teams Town halls: Upload custom backgrounds in Manage what attendees see [MC1307982] 3 pexels steve 27578992](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
- (Updated) Microsoft Teams: Unblock users to send message while file is uploading in the background [MC1317836]
![(Updated) Microsoft Teams: Unblock users to send message while file is uploading in the background [MC1317836] 4 pexels jeshoots com 147458 451590](data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==)
![Microsoft OneNote: Copilot notebook available in OneNote on Mac [MC1409042] 1 pexels yankrukov 8866797](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-yankrukov-8866797-150x150.webp)
![(Updated) Microsoft Teams: Proximity join support for presenters in Teams events from Teams Rooms on Windows and Android [MC1319213] 2 pexels divinetechygirl 1181248](https://mwpro.co.uk/wp-content/uploads/2025/06/pexels-divinetechygirl-1181248-150x150.webp)
![(Updated) Microsoft Teams Town halls: Upload custom backgrounds in Manage what attendees see [MC1307982] 3 pexels steve 27578992](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-steve-27578992-150x150.webp)
![(Updated) Microsoft Teams: Unblock users to send message while file is uploading in the background [MC1317836] 4 pexels jeshoots com 147458 451590](https://mwpro.co.uk/wp-content/uploads/2024/08/pexels-jeshoots-com-147458-451590-150x150.webp)