2 Pivot tables on 1 sheet

G

Guest

I currently have 2 pivot tables on 1 sheet directly above each other, with
all the total hidden so that it looks continuos. The reason I am using 2
pivot tables is as the data comes from different sheets.

The problem I have got is when I refresh the top pivot table as the contents
of the sheet it is pulling from is populated with more data it says that 'A
Pivot Table report cannont overlap another PivotTable report'

Is there anyway that I can prevent this from happening?

Can you set the format like on a chart where the pivot table will move if
more cells are inserted.

I hope that I have explained this well enough!

The Rook
 
G

Guest

Hi TheRook,

is possible to have one Pivot table with two different sources, or not
continuous ranges.

Regards from Brazil
Marcelo


"TheRook" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding to an existing Pivot Table 7
Pivot Table - Changes 5
Pivot Table update 8
Pivot Data and Filter on separate sheets 1
One pivot table cannot overlap another pivot issue. 1
Pasted Pivot Table looks at old sheet 1
View Pivot Table Source data as a Data Table 6
Question on the occupied field of the pivot table in excel spreadsheet 0

Top