Microsoft Excel - Pivot Table Source in Excel 2003
Asked By Patricia Camon on 20-Jul-09 01:05 PM
Once a pivot table is created, how can you determine or verify the data source? In other words wheer is the data source indicated?
We need to use the Pivot Table wizard - [)ia6l0 iii replied to Patricia Camon on 20-Jul-09 03:02 PM
In 2003, i guess you would select the pivot table and choose the Pivot Table wizard and hit back twice. That would show you the range/data source.
In office 2007, we need to use the "Change Data Source" option under
the "Options" tab to determine the pivot table's data source.