| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 pivot table source table
In previous versions of Excel you could right click on a pivot table, select
Pivot Table Wizard, then click the back arrow button to check the source data table, worksheet, or file, and change the range. How to do this in Excel 2007? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 pivot table source table
I notice that if you right click in the pivot data and select Show Details,
it inserts a new worksheet showing the source data. However since you're not viewing the source worksheet, you have no assurance that all rows have been included (if you've added some to the source sheet) and there's no indication of which worksheet it's working from. "sb" wrote: In previous versions of Excel you could right click on a pivot table, select Pivot Table Wizard, then click the back arrow button to check the source data table, worksheet, or file, and change the range. How to do this in Excel 2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| source data for pivot table 2007 | Excel Discussion (Misc queries) | |||
| How do I set Excel 2007 pivot table default to not save source dat | Excel Discussion (Misc queries) | |||
| View pivot table external data source in Excel 2007 | Excel Discussion (Misc queries) | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Linear Mode
