How to check Pivot Table source?

  • Thread starter Thread starter Marcin Peciak
  • Start date Start date
M

Marcin Peciak

Hi,

I use a file created in Excel 2003 and need to check if the Pivot table
calls proper ranges. Is there any way to check what the source for the Pivot
is? And, can the source range be redefined for this Pivot?

I don't want to just start new pivot from scratch, as there are different
formulas on that spreadsheet that uses its values.

Thanks,
Marcin
 
Hi Marcin,
I use a file created in Excel 2003 and need to check if the Pivot table
calls proper ranges. Is there any way to check what the source for the
Pivot is? And, can the source range be redefined for this Pivot?
Click to expand...

Select a cell in the pivot table. Then open the pivot table wizard (Data ->
Pivot Table and Pivot Chart Report). Click the back button. You will be in
step 2 of the wizard and be able to see and change the data range.

Ed Ferrero
www.edferrero.com
 
Hi,

If you are using 2007:

Select anywhere in the pivot table and choose PivotTable Tools tab, Options
tab, Change Data Source.
 
Back
Top