Hi,

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MichaelRobert" wrote:

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