How to check Pivot Table source?
Hi,
If you are using 2007:
Select anywhere in the pivot table and choose PivotTable Tools tab, Options
tab, Change Data Source.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Marcin Peciak" wrote:
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
|