Recommended PivotTables are now more intelligent by utilizing the same technology as the Analyze Data feature. In addition, the dialog box interface has been replaced with an all-new redesigned panel. This updated user experience makes it easier to view all of your options, and simpler to change your data selection before inserting a recommended PivotTable. We are continuing to work to enhance this feature, and your feedback is always welcomed and encouraged!
Click here to try it yourself > |
How it works
Ready to give the improved Recommended PivotTables experience a try?
Click here to try it yourself > |
This feature is currently available to Microsoft 365 subscribers in English, French, Spanish, German, Simplified Chinese, and Japanese. Support for more languages is coming soon.
Recommended PivotTables currently does not support the analysis of datasets larger than 1.5 million cells. As an alternative, you can filter and reduce your data set to a supported number of cells, copy it to another location, and then run Recommended PivotTables on that smaller data set.
To take advantage of this feature, you must have:
The improved Recommended PivotTables experience analyzes your data with intelligent services. You can access the Microsoft Privacy Statement for additional details on data security.
Recommended PivotTables uses material from third parties. To learn more about third-party intellectual property, review this licensing information (for a related Excel feature).
We will be rolling out the improved Recommended PivotTables experience to Office Insiders running Beta Channel Version 2204 (Build 15128.10000) or later.
Don’t have it yet? It’s probably us, not you.
Features are released over some time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly released to larger numbers of Insiders. Sometimes we remove elements to further improve them based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product, even if you, as an Insider, have had the opportunity to try it.
We want to hear from you! Please click Help > Feedback to submit your feedback about this feature; be sure to mention “Recommended PivotTables” in your comments.
Learn what other information you should include in your feedback to ensure it’s actionable and reaches the right people. We’re excited to hear from you!
Do you have an idea to make Excel better? We'd love to hear about it. Go to the Excel forum in Microsoft Feedback to submit your idea or vote for other ideas. You can also click the Feedback button in Excel and choose "I have a suggestion".
Sign up for the Office Insider newsletter and get the latest information about Insider features in your inbox once a month!
Want to know more? Subscribe to our Excel 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.