software

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

Thanks

Stilla

With your cursor in the body of the pivot table, open the pivot table wizard,
then click the quot;backquot; button.

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

quot;Stillaquot; wrote:

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

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

quot;simmerdownquot; wrote:

gt; With your cursor in the body of the pivot table, open the pivot table wizard,
gt; then click the quot;backquot; button.
gt;
gt; That will show you the data range used to create the pivot table.
gt;
gt; quot;Stillaquot; wrote:
gt;
gt; gt; Hi,
gt; gt; How do I re-check or modify the data range that a pivot is referring to?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Stilla