How to remove PivotTable format.

[MichaelRobert]

Probably a dumb question with an obviuos answer,but I don't see it.

I have been sent an Excel Read-only workbook but the worksheet is formatted
as a PivoTable report. As a result - even though I have made a copy of the
Read-only report, I cannot sort the data in the worksheet - I can only filter
it.

I can see how the PivotTable sheet would have been created - by using the
original data set, creating a PivotTable report, and saving it as a new
workbook. But how can I reverse the process and get back to the original data
set?

What is the secret?

Thanks.

Mike

 

[MichaelRobert]

Sorry about the duplicate postings. But I got a sysem error message both
times telling me that the post was n ot received ...

Mike

 

[Roger Govier]

Hi Michael

If the PT report was saved with the Pivot Cache, then double clicking the
Total value (bottom right of table) will open another sheet with a copy of
the underlying data.

If under table Options, the original file was saved without the Save Data
with Table layout checked, then there is no way you can get at the source
data.

 

[MichaelRobert]

OK. It wasn't the question that was dumb - it was the questioner!

The format that I wanted to remove was not PivotTable, it was Autofilter.
And a simple click on Data to uncheck Autofilter did the trick.

Quote from Dr. Bill Summers, FSU : "It is not what we don't know that will
get us into trouble; it's what we know that just ain't so!"

Mike