View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MichaelRobert MichaelRobert is offline
external usenet poster
 
Posts: 64
Default 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