Get instant live expert help on I need help with pivot table wizard

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

When I go into Power Pivot in Excel 2019 and select Get External Data From Other Sources I get nothing, no Table Import Wizard.
Solved by B. H. in 21 mins
I am trying to get a pivot table to add the amount of fees for separate months from separate spreadsheets. I was trying something with the Pivoting Wizard, but it was too much for my 32 bit Excel.
Solved by K. A. in 24 mins
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
When I go to Power Pivot/Get External Data/From Other Sources, nothing happens. No popup or wizard shows
Solved by M. H. in 11 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins