Nov 23, 2011 I'm studying a course, and it shows how to create a pivot chart in excel 2010, but the insert tab does not exist on excel 2011, and where there is a pivot table creation button there is. In Excel, a pivot table can help you summarize your data based on different. Before creating a pivot table, we need to make sure our dataset is well organized.
Hello, I am currently taking an online Excel course which is now going over Advanced Pivot Table functions. I am aware that I am unable to access many of these functions as I currently only have Excel 2011 on my Mac (so no access to Timeline or Slicers). One feature that I am unsure works or not, though, is multiple pivot tables on one sheet.
![Pivot Pivot](https://www.howtogeek.com/wp-content/uploads/2009/11/1piv.png)
![Excel Excel](https://www.accountingweb.com/sites/default/files/styles/content_full_width/public/figure5.jpg?itok=cqZyKO3v)
I am trying to create a Pivot Table and place it in an existing worksheet (so that I may see multiple pivot tables using the same data range on one sheet), and I cannot seem to get it to work. I select my data, choose the Pivot Table option, and then under 'Existing Worksheet' I select the sheet and then a cell that does not overlap with an existing Pivot Table. However, when I click OK, I get taken back to my data table, and no Pivot Table is created. I have noticed online that other Mac Excel 2011 users have this problem, too, but I just want to know if this is because of Mac Excel 2011 itself, or if my computer might be having problems.
I can also confirm that the 'Move' option to move a Pivot Table into an existing Worksheet also does not work, which makes me think this is something I should be able to do, but perhaps my computer is having problems? Thank you in advance for any clarification you may have. Hi CLNguyenExcel, I did a simple test: Enter some data in book1-sheet1, select all the data>click the Data tab>Pivot Table>Manually create a pivot table>Existing sheets>click the button next to Location>select a rang in book1-sheet2>it creates the first pivot table. And then, I return to book1-sheet1 repeat steps mentioned above, select another range in book1-sheet2, it creates the second pivot table. And then, I click one cell in the second pivot table>click Pivot Table tab>Move> click the button next to location>select a range in book1-sheet3>it moves the second pivot table to sheet3. If these are same steps which you use, the two functions should work. If not, please record a video about how you operate these two functions.
We want to check if we can reproduce the behavior from our side. You may just use mobile phone or to record the video.
Upload it to a public cloud storage (share with us a guest link. So, other community members can also discuss on this thread) or my. Moreover, please click Excel icon on the top bar>About Excel>let us know the detailed version of your Office 2011 for Mac. Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology. If anything is misunderstood, let me know. Best regards, Tim.