Question: how to extract data from excel using pivot table?
Answer: Select the pivot table by clicking a cell within it. Click the Analyze tab's Select command and choose Entire PivotTable from the menu that appears. ...  Copy the pivot table. ...  Select a location for the copied data by clicking there.