Pivot Table Data Source
 

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.
--
Always grateful for help!!

Pivot Table Data Source
 

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

SusanJane sjl wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html