Welcome to the June 2026 update and happy Pride Month! This year’s theme, Pride is Alive, is a powerful reminder that Pride is not just about showing up—it’s about living openly, authentically, and fully. Show a touch of Pride in Excel on iOS and Mac by personalizing your app with Pride themes.
In addition to the LSEG and Moody's connectors we released late last month, we're expanding your options with more financial data connectors for bringing public and private market data into Copilot in Excel: CB Insights, Daloopa, FactSet, Morningstar, PitchBook, and S&P Global - Deterministic Retrieval. Other new connectors this month include HubSpot, Intercom, Linear, Notion, Canva, Google Calendar, and Google Contacts, along with support for Claude Opus 4.8 models. Read more here >
New features and enhancements in Excel this month include:
Excel for Windows, Mac, and web:
- Personalization with Copilot in Excel
- Navigable links in the Copilot Chat response #FIA
- Bring more of your work context into Copilot in Excel
- Analyze more content, including large files with Copilot in Excel
- PivotTable #SPILL!
Excel for Windows and Mac:
- Custom skills (Insiders)
- Workbook rules with Copilot in Excel (Insiders)
Excel for Windows, Mac, and web
Personalization with Copilot in Excel
With personalization, you can customize Copilot in Excel to return results based on your preferences. When you set personalization preferences, they're saved to your account and are applied to all your workbooks and Copilot in Excel sessions. Read more here >
Navigable links in the Copilot Chat response #FIA
We've added a new feature to the chat response in Excel Copilot that will help you understand what changes are made, right in the context of the response. With each response where there is a table, chart, shape, range, or cell reference with edits, you can see the change and click on it from the response to navigate to the area in the workbook. Quickly jump from sheet to sheet, chart to table, and to specific cells all while reading the output.
Bring more of your work context into Copilot in Excel
Bring more work context into Copilot in Excel by going beyond documents to include people, emails, meetings, Teams chats, channels, Loop pages, and web content—all accessible through the file picker. Incorporate conversations, decisions, and collaborative notes directly into your analysis to generate more informed insights without switching tools.
Analyze more content, including large files with Copilot in Excel
Bring a wider range of business content into Copilot in Excel with support for 30+ additional file types (json, xml, tsv, zip, md, gif, bmp, svg, webp, html, loop, py, css, c, cpp, java, sql, aspx), for uploading code, structured data, images, archives, and saved emails. With support for large file sizes (50 MB), you can work across extensive datasets, workbooks, and PDFs. This enables deeper analysis and insight extraction from complex information at scale, all within Excel.
PivotTable #SPILL!
PivotTables can now collapse into a single cell with a #SPILL! error when they can’t expand because something is in the way – so you can stay focused and resolve errors on your own terms. To clear the error, try clearing any blocking cells, moving the PivotTable to a different location, or try using the "Select Obstructing Cells" option to locate the obstructing cells. Read more here >
Excel for Windows and Mac
Custom skills (Insiders)
Skills lets you define how Copilot should complete common processes such as building a DCF model, closing the books, refreshing a monthly reporting model, or preparing a variance analysis. Instead of starting from scratch each time, a skill guides Copilot through the steps, applying the right structure and formatting, and helping produce an output that is easier to review, reuse, and trust. Custom skills are available today via the Insiders channel for Windows and Mac, and rolling out to general availability across Excel for Web, Windows, and Mac next month. Read more here >
Workbook rules with Copilot in Excel (Insiders)
Where Personalization is about you, workbook rules are about a specific workbook. Rules live in the workbook and travel with it when you share it, so teams and organizations can standardize how a file should look and behave, and everyone who uses Copilot to edit it stays consistent. These rules are stored in the workbook as a sheet with the “.Rules” naming convention, which signals to Copilot that they should be followed for all edits made in the workbook, regardless of the user. Read more here >
Check if a specific feature is in your version of ExcelClick here to open in a new browser tab
|
Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps improve Excel for everyone. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion". You can also submit new ideas or vote for other ideas via Microsoft Feedback.
Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.
Special thanks to our Excel MVPs David Benaim, Bill Jelen, Alan Murray, and John Michaloudis for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel. Alan is an Excel trainer, author and speaker, best known for his blog computergaga.com and YouTube channel with the same name. John is the Founder & Chief Inspirational Officer at MyExcelOnline.com where he passionately teaches thousands of professionals how to use Excel to stand out from the crowd.
