Getting rid of PivotTable format
 

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

Getting rid of PivotTable format
 

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