Excel: convert a Pivot to worksheet

[swisschris]

Hi all,

does anbody know, how to convert a Pivot table in Excel 2003 into a 'normal' worksheet? - I know, this sounds a bit strange, but in the Pivot auto-filters appear above the header lines and also include the headers as filter criteria (means the headers are gone after selecting a different value). Up to now, I always copy and paste the formats and values into a new worksheet and define the filters there... Maybe it's also possible to have the filters below the headers? - I didn't find out, how to do that.

Thanks a lot,
Chris

 

[SkipVought]

hi,

oes anbody know, how to convert a Pivot table in Excel 2003 into a 'normal' worksheet?

Copy

Edit > Paste Special -- VALUES


I do not understand the remainder of your question.



Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[swisschris]

Hi,

for the moment I copy the content of a Pivot table into a blank spreed sheet. I want to omit this step and was wondering, whether one could somehow convert the Pivot table into a 'normal' worksheet.

Thx,
Chris

 

[SkipVought]

Use the stated process.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[swisschris]

thx, that's what I've been doing up to now...

 

[SkipVought]

I meant, that you can do that IN PLACE on the existing PT, if so desired. You do not have to copy to a DIFFERENT sheet or range.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[swisschris]

nice one. That works fine. I had thought, that Excel would refuse to do that...

Thanks a lot for your help!

Cheers,
Chris