Pivot Table Data Source

S

SusanJane sjl

I'm adding a worksheet pivot table based on the same data source as another
worksheet in the same excel file. In a similar instance previously I got a
message asking if I want the source to be the same as the existing worksheet
to save space. Now I can't that message to come up and the size of my file
is double. I tried to identify that pivot table as the data source but it
wouldn't retrieve any data.
 
D

Debra Dalgleish

Right-click on the second pivot table, and choose PivotTable Wizard
Click the Back button, to return to Step 1
Select Another PivotTable report or PivotChart report
Click Next, and choose the first pivot table
Click Finish
 
Top