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

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

Mike

"MichaelRobert" wrote:

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

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.

--
Regards
Roger Govier

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

Mike

"MichaelRobert" wrote:

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

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

"Roger Govier" wrote:

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.

--
Regards
Roger Govier

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

Mike

"MichaelRobert" wrote:

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