How do you convert a pivot table to excel worksheet

  • Thread starter Thread starter MS at CORE
  • Start date Start date
M

MS at CORE

How do you convert a pivot table to a regular excel worksheet? All I can
find are instructions on how to convert excel worksheet to a pivot table but
not the other way around. I do not have a data source file since the pivot
table was e-mailed to me. I need to combine this file with excel worksheet
to sort data to compare and find missing information from excel worksheet.

Thank you for your help!
 
Do you mean copying the data displayed in the pivot table into excel
as a regular table? If so, you can highlight the cells and copy then
paste into another area.

Or do you want the underlying data as well?
 
I was hoping to find a quicker way than copying and pasting but I guess not.
Thank you for your help!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table source table 1
Single Filter to change all Pivot Tables in a Workbook 8
Pivot table data source 1
Pivot Table Data Source 1
Duplicating Pivot Chart / Changing Pivot Chart data range 4
Pivot table drill down data 2
pivot table source data expand to new entries when refresh? 4
Value filter missing in pivot table 3

Back
Top