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.