Older woman working on laptop

Improved Recommended PivotTables experience in Excel

Feature deep dive
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn

Hi, Office Insiders! My name is Olivia Thomas, and I’m a Product Manager on the Excel team. I’m excited to introduce our new and improved Recommended PivotTables experience in Excel for Windows.  

Improved Recommended PivotTables experience

Recommended PivotTables are now more intelligent, utilizing the same technology as the Analyze Data feature. In addition, we have replaced the dialog box interface with a 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 continue to work on enhancing this feature, and your feedback is encouraged!

Screenshot of Excel for Windows showing Recommended PivotTables pane.

How it works

Ready to give the improved Recommended PivotTables experience a try?

1. Open an Excel workbook containing data (see the Tips and Tricks section below for more details on what kinds of data work best).

2. Select Insert > Recommended PivotTables.

Recommended PivotTables button on the Excel for Windows ribbon.

3. In the Recommended PivotTables pane, review the suggested options.

Recommended PivotTables pane in Excel for Windows.

4. If desired, place your cursor in the Source box and choose a different data selection on the grid.

GIF showing how to insert cursor into Source box in the Recommended PivotTable pane in Excel for Windows.

5. Select either +New sheet or +Existing sheet to insert the recommended PivotTable in your workbook.

GIF showing how to select a table for insertion into your workbook in the Recommended PivotTable pane in Excel for Windows.

Supported languages

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. 

Known issues

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. 

Tips and tricks

  • Use clean, tabular data for best results.
  • Format your data as an Excel table (click anywhere in your data and press Ctrl+T). 
  • Make sure all columns have headers, with a single row of unique, non-blank labels for each column. Avoid double rows of headers or merged cells.
  • If you have complicated or nested data, use Power Query to transform it (for example, to unpivot your data) so it is organized in columns with a single header row.  


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 releasing 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!

Sign up for the Office Insider newsletter and get the latest information about Insider features in your inbox once a month!