What's New in Excel (September 2022)
Published Sep 27 2022 06:00 AM 18K Views
Microsoft

Welcome to the September 2022 update. We are excited to announce the release of Check Performance for Excel web users to help speed up your workbooks and modern comments for Windows users to allow for a more streamlined commenting experience across products. For Insiders using Mac, you can now shape your data using the Power Query Editor and manage your storage accounts for 1st and 3rd party profiles.

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel

 

Excel for the web

  • Check performance
  • Sharing a section of Excel workbook
  • Dynamic array support in charts

Excel for Windows

  • Modern comments
  • Dynamic array support in charts (Insiders Beta)

Excel for Mac

  • Shape data with Power Query Editor (Insiders Preview)
  • Manage your storage accounts (Insiders Preview)

 

Excel for the web

Check Performance

Now when you open your workbook, Excel can detect whether your workbook contains unwanted formatted cells that can slow down your workbook. If so, Excel suggests launching “Check Performance.“ You can also manually launch the feature from Review > Check Performance. Read more and try it yourself >

Check PerformanceCheck Performance

 

Sharing a Section of Excel Workbook

Whether collaborating through Teams or on the web, you may want to share information from a workbook. You can share the entire workbook, but often it’s safer, faster, and more efficient to share just a section of the workbook for viewing or editing. You can now easily share with others a link to a specific range, table, or chart.  Read more >

 

Share a Section of a WorkbookShare a Section of a Workbook

 

Dynamic array support in charts

Charts now respond to dynamic arrays! Create a chart with a data source range aligned to the result of an array formula. The chart will now update to capture all data whenever the array recalculates, rather than being fixed to a specific number of data points.

 

Dynamic Array SupportDynamic Array Support

 

 

 

Excel for Windows

Modern Comments

Modern comments in Excel for Windows are now built on the React Native framework, and you will now find people images are clickable showing their contact card details; comments can display both on the grid and in the side pane at the same time; and new icons for edit, resolve, and reactivate are available on the card.

 

Modern Comments across platformsModern Comments across platforms

 

Dynamic array support in charts (Insiders Beta)

Charts now respond to dynamic arrays! Create a chart with a data source range aligned to the result of an array formula. The chart will now update to capture all data whenever the array recalculates, rather than being fixed to a specific number of data points.

 

Excel for Mac

Shape data with Power Query Editor (Insiders Preview)

You can now clean and shape your data from local files, SharePoint, SQL, as well as from tables and ranges using the Power Query Editor in Excel for Mac. Read more >

 

Launch Power Query Editor from the Data tabLaunch Power Query Editor from the Data tab

 

Manage Your Storage Accounts from Mac (Insiders Preview)

Add and manage first– and third–party accounts and services in Excel for Mac - as well as others Office apps for Mac. The same Add Storage Accounts feature you love using in the Office Mobile apps is now available on your Mac. It is a redesign of the previous “Add a Place” experience in the Open tab. By using this feature, you can easily add a SharePoint site, a OneDrive or OneDrive for Business account, or even a third-party account like Box. Read more >

 

Manage Your Storage AccountsManage Your Storage Accounts

 

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.  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 Twitter.

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel

 

11 Comments
Version history
Last update:
‎Sep 26 2022 01:41 PM
Updated by: