Recommended Pivot Tables

Question

When you click recommended pivot tables, a pop up should appear with the recommended tables. I do not get a pop u and only the field list pops up. Has anyone else had this issue or know how to get the pop up to return?

I am using Mac 2016 version of excel.

Answer 1

Hi Susann,

We haven't heard from you for a while, would you please confirm the information above to help us confirm your situation?

Regards,

Tisky

Answer 2

Is it possible for you to post a screenshot of your problem?

Answer 3

Install the 16.16 update.

The recommended pivottables feature is new and was not fully implemented until this update. It works now!

If your Mac is managed by an IT department, have them install updates.

Otherwise, make sure your Mac has a working internet connection before checking for updates. Install Mac OS X updates followed by Office updates.

---

Install Mac OS X updates first:

To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.

---

Then Install Office Updates

To get the update:

1. Open any Office application
2. Go to the Help menu and choose Check for Updates
3. Let AutoUpdate check for and install updates
4. Restart your Mac

If you have any add-ins such as WebEx, Mendelay, EndNote, Zotero, TypeIt4me, etc it is essential that you install the latest updates for your add-ins.

On the other hand, I have 16.17 and it stopped working. Maybe they turned it off. I'll check.

Answer 4

Hi Susann,

Based on our test, when you select the table and click Recommended Pivot tables, it will directly change the data into a pivot table. It seems like an expected behavior even in old versions. So we'd like to confirm some information.

1. In which version did the pop-up windows appear?
2. Please share your current Excel version with us, you can check it in Excel > About Microsoft Excel.

Regards,

Tisky