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?