Pivot Table Data Source

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top