I need the Pivot Table Wizard in Excel from Office Home and Student 2016 for Mac. The Cmd-Opt-P that works in Excel 2011 for Mac won't work in the 2016 version. I need to add ranges.
The Change Data Source doesn't work: it says because I have dat "from multiple consolidation ranges" and it says to use "Command + Option + P" which doesn't work.
Is there another way of bringing up the Pivot Table Wizard?
Solved by G. Q. in 14 mins