I have a worksheet that I created as a table. I have another worksheet where I am putting together reports. I already have a pivot table using my Table name which is Table1. I want to create another pivot table using the same Table1 on the same reporting worksheet. Will it allow me to create more than one pivot table on the same worksheet using the same table name? I tried but was having problems.

AFAIK, you can create as many as you want.

Does not seem to be working. When I created another pivot table using Table 1 it seems to be changing my first pivot table.

Attach your sheet.

I have attached the sheet. I used the table2 as the data range for both. I clicked on Pivot Table options for both and it has the as Pivottable1 and PivotTable2. Is it still using my table as a source? My table is called Table. As I add I want it to refresh and add everything new.

Also, in cell K2 I have the text video twice. I used a countif function to count that column but it is only counting video in that field once. Do you have any suggestion on what formula to use to calculate it twice in that field?

Attached Files

Test pivot.xlsx (55.1 KB, 7 views)

table1 is the source for both pivot tables. They seem to work for me.

As for counting video twice, no I don't really have any thoughts on that. Not sure why you want to, but I bet there are far better ways of doing this.

Thank you for your help.