Checking data range in Pivot
 

Hi,
How do I re-check or modify the data range that a pivot is referring to?

Thanks

Stilla

Checking data range in Pivot
 

With your cursor in the body of the pivot table, open the pivot table wizard,
then click the "back" button.

That will show you the data range used to create the pivot table.

"Stilla" wrote:

Hi,
How do I re-check or modify the data range that a pivot is referring to?

Thanks

Stilla

Checking data range in Pivot
 

WOW! SO simple... I would have never thought of it . THANK YOU!!!

"simmerdown" wrote:

With your cursor in the body of the pivot table, open the pivot table wizard,
then click the "back" button.

That will show you the data range used to create the pivot table.

"Stilla" wrote:

Hi,
How do I re-check or modify the data range that a pivot is referring to?

Thanks

Stilla