So, other community members can also discuss on this thread) or my Upload it to a public cloud storage (share with us a guest link. We want to check if we can reproduce the behavior from our side. If not, please record a video about how you operate these two functions. If these are same steps which you use, the two functions should work.
Repeat steps mentioned above, select another range in book1-sheet2, it creates the second pivot table.Īnd 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. Thank you in advance for any clarification you may have.Įnter 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. 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? 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. However, when I click OK, I get taken back to my data table, 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. 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 One feature that I am unsure works or not, though, is multiple pivot tables on one sheet. 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). I am currently taking an online Excel course which is now going over Advanced Pivot Table functions.
0 kommentar(er)
