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.