Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

All solutions PIVOT TABLE
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 40 mins
I created a pivot table linked to source data in a separate worksheet and the pivot table was distributed to employees. The data had confidential in it that was accidentally included. I thought deleting the sheet with the data source would break the pivot table, but that is not the case. Can I do anything to corrupt the pivot table?
Solved by I. J. in 40 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 48 mins
i need to pull employee numbers and names and match them on a new worksheet using pivot table?
Solved by S. H. in 20 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 11 mins
can not turn my data into a pivot table... reference invalid
Solved by I. B. in 39 mins
Ok, I am trying to create a running workbook where I have data in different tabs (each tab is one month) that I want to add values to, and create a ytd summary tab that will track how much is being spent for each month, I am attempting to use the data model pivot table tool but am having trouble building the relationships, is there an easier way to do this ?
Solved by V. Y. in 40 mins
I have a pivot table in which per order (on the rows) stands how much products they ordered per size (on the columns). I want to determine which combinations of quantities of sizes people order. And I want to count these combinations.
Solved by E. W. in 60 mins
I need help making my pivot table look cleaner and filtering some information
Solved by S. Q. in 60 mins
Ok, I am trying to create a running workbook where I have data in different tabs (each tab is one month) that I want to add values to, and create a ytd summary tab that will track how much is being spent for each month, I am attempting to use the data model pivot table tool but am having trouble building the relationships, is there an easier way to do this ?
Solved by Z. Y. in 60 mins
1 2 6 7