![]() ![]() The optimizations should be especially noticeable on low-end devices that have less memory or slower CPU-memory throughput.ĭataflow and Dataverse connectors (Monthly Enterprise Channel and Current Channel)ĭataflows are a self-service, cloud-based, data preparation technology. Users should now find AutoFilter noticeably faster! Improvements were made to reduce memory usage and optimize calls made by the filter’s comparison algorithm. Note that in some cases that require compute-intensive calculation, users may want to consider overriding this default by setting Number of calculation threads to “2.” For more details, see the Formulas section of the Advanced Options page on the Microsoft Support site.įaster AutoFilter (Monthly Enterprise Channel) In most cases, users should see noticeably faster calculation on these devices. On resource constrained devices, Excel has now by default made recalculation more optimal by running calculation on a single thread. Read more >įaster recalc on resource constrained devices (Current Channel) ![]() ![]() A redesigned panel makes it easier to view all of your options, and simpler to change your data selection before inserting a recommended PivotTable. Recommended PivotTables are now more intelligent, utilizing the same technology as the Analyze Data feature. Improved recommended PivotTable experience (Insider Beta) In addition to open, refresh, and break links, you can now change the source file in workbook links in Excel for the web. Power Query refresh for selected data sourcesīy far one of the most popular requests we have received from Excel users, Power Query refresh is now available for queries sourcing data from the current workbook and anonymous OData feeds. Shaping data with Power Query Editor (Insider Beta).Running Office Scripts from a workbook button (Current Channel).Dataflow and Dataverse connectors (Monthly Enterprise Channel and Current Channel).Faster AutoFilter (Monthly Enterprise Channel).Faster recalc on resource constrained devices (Current Channel).Improved recommended PivotTable experience (Insider Beta).Changing source file for workbook links.Power Query refresh for selected data sources.For Insiders, we've released an improved recommended PivotTable experience in Excel for Windows and the ability to get and shape data with the Power Query Editor in Excel for Mac.Ĭheck out this Excel Features Flyer to find if a specific feature is in your version of Excel We are excited to share the general availability of Power Query refresh for selected data sources and the ability to change the source file for workbook links in Excel for the web and performance improvements across Excel for Windows and Excel for Mac making AutoFilter noticeably faster, for example. Starting this month, we on the Excel team bring you a regular recap of the key features and improvements now available across Excel for the web, Windows, Mac, and mobile. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |