Getting rid of PivotTable format

  • Thread starter Thread starter MichaelRobert
  • Start date Start date
M

MichaelRobert

Probably a dumb question, but how do I get rid of the PivotTable formatting
to return to the original Excel spreadsheet.

I have been sent a Read-only copy of an Excel workbook. All the data I want
is in there, but it is set up as a PivotTable report and I cannot sort the
data (I can only filter it). I have made a copy of the Read-only file but I
cannot reove the PivotTable format.

What is the secret?

Thanks.

Mike
 
Hi,

Select what you want and choose copy, move to another location and choose
Edit, Paste Special, Values.
 
Back
Top