Hi, How do I re-check or modify the data range that a pivot is referring to? Thanks Stilla
S Stilla Mar 28, 2006 #1 Hi, How do I re-check or modify the data range that a pivot is referring to? Thanks Stilla
S simmerdown Mar 28, 2006 #2 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.
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.
