Consolidated Pivot Tables Excel 2016 Mac

Dear Community,

I would like to know how to do consolidated pivot tables on the new excel 2016 for mac. Before it was possible to activate the pivot table Wizard by pressing Cmd + Alt + P but that does not work anymore and I cannot find any other way to access it. Anybody experience with that?

Any help is appreciated!

Thank you!!!

 

Question Info


Last updated December 10, 2019 Views 10,065 Applies to:

Are you referring to the Pivot table Builder, if yes then double click on any cell on the pivot table and it should be you the PivotTable Analyze ribbon.

1 person was helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

It appears Joe has no clue about this. All it would take for him to do is to press Cmd + Alt + P in 2011 to see what happens. But I guess he couldn't be bothered.

As you already know, when you press Cmd + Alt + P is a keyboard shortcut to display the PivotTable wizard. The wizard has been cut from 2016. The Ribbon is supposed to replace the wizard. 

If you can provide a step-by-step what you are doing in 2011 in a reply perhaps someone out here in internetland can explain how to do the same thing 2016.

I am an unpaid volunteer and do not work for Microsoft. "Independent Advisors" work for contractors hired by Microsoft. "Microsoft Agents" work for Microsoft Support.

4 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

It appears Joe has no clue about this. All it would take for him to do is to press Cmd + Alt + P in 2011 to see what happens. But I guess he couldn't be bothered.

As you already know, when you press Cmd + Alt + P is a keyboard shortcut to display the PivotTable wizard. The wizard has been cut from 2016. The Ribbon is supposed to replace the wizard. 

If you can provide a step-by-step what you are doing in 2011 in a reply perhaps someone out here in internetland can explain how to do the same thing 2016.

Not sure about MAC products or functionality but you can use the wizard in Office 2016.

My Employer upgraded use to Windows 10 and Office 2016.  The Wizard is still available.  It can be added to a new group in the ribbon.  It can still be accessed via shortcut by using <Alt>+<D> then <P> as usual.  However, on our network, step 3 of the wizard will fail if you choose to put the pivot table in a new sheet.  It still works if I select existing sheet.  I can then cut/paste the newly created pivot table to a different sheet afterwards.  This issue started with a recent update of Microsoft server side products on our network.  Our I.T. folks are fairly clueless as to how to fix this and I can not find documentation from Microsoft on the problem or solution.  Weird.  If, however, you do not use consolidation ranges in pivot table functionality then you do not need the old wizard.  I do not, therefore I should just use the newer 2-step process off the existing menu.  

3 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.