What's New in Excel (February 2023)
Welcome to the February 2023 update. This month we are bringing the ability to manually sort row and column values in PivotTables to users of Excel for the web. For Insiders, those using Excel for Windows can check out automatic recalculation optimization and blocking untrusted XLL add-ins; and those using Excel for Mac, Power Query Editor to import data from SQL Server databases – as well as from additional sources such as SharePoint, local files, OData, and many others.
Excel for the web:
Excel for Windows:
Excel for Mac:
PivotTables: Manual sort (drag) of rows and column values
Excel for the web just got even better with manual sorting for PivotTables and PivotCharts. Now you can customize the sort order of your PivotTable row and column items beyond the standard ascending and descending options. This feature, previously only available in the Excel desktop app, allows you to manually sort specific row or column items by dragging them or using the context (right-click) menu. With this new feature, organizing and analyzing your data is now more flexible!
Automatic Recalculation Optimization (Insiders)
Block untrusted XLL Add-Ins (Insiders)
Power Query Editor
Import Data from Additional Sources
Import Data from SQL Server Databases (Insiders)
Automatic Recalculation Optimization (Insiders)
