Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Source Data | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
Pivot Table data source | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Pivot Table Source Data | New Users to Excel |