Pivot Table Data Source

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

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

Pivot Table Data Source 1
Pivot table data source 1
Excel 2007 pivot table source table 1
Identifying Source Data for Pivot Tables 2
Pivot Table Update 3
Pivot table change data source 1
Pivot Table Data Source 1
pivot table source data expand to new entries when refresh? 4

Top