Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format PivotTable | Excel Discussion (Misc queries) | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
pivottable on web | Excel Discussion (Misc queries) | |||
PivotTable - cell format | New Users to Excel | |||
how can i do a conditional format in a PivotTable? | Excel Worksheet Functions |