Are you stuck on Excel or Google Sheets?

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?

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?

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

i need to pull employee numbers and names and match them on a new worksheet using pivot table?

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.

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 ?

can not turn my data into a pivot table... reference invalid

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.

I need help making my pivot table look cleaner and filtering some information

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 ?