Get instant live expert help on How do I change data source pivot table excel 2016

“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

Excel 2016 pivot table returning zeros instead of data
Solved by B. B. in 18 mins
Cannot change pivot table source to new file... cannot upload pivot to this site.
Solved by C. J. in 19 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
Sir, I want to change the data source of my pivot table to another data source in another spreed sheet, how can I go about it in Google spreed sheet? Thanks
Solved by S. C. in 11 mins
Updating pivot chart w updated source data: hi, I've updated the source data after starting the pivot table (sheet 1). how do I update the pivot table fields and table with the data I've added?
Solved by M. D. in 20 mins