How do I identify the source data in an existing Pivot Table?
C cottage6 Oct 12, 2005 #2 Hi Lisa, Right-click an area of the pivot table, and click on "Wizard". When the Wizard opens it'll be on Step 3, but if you click the "Back" button it'll move to Step 2 which should show you the data range.
Hi Lisa, Right-click an area of the pivot table, and click on "Wizard". When the Wizard opens it'll be on Step 3, but if you click the "Back" button it'll move to Step 2 which should show you the data range.
