How do I filter displayed columns when double click in a pivot tab
 

When I double click in a field from a pivot table excel generates a new
worksheet with all rows containing the information I choose, but it also
includes all columns from the database to which the pivot table is refering
to. Is there a way to choose just the columns I need?

Excel version 2003

How do I filter displayed columns when double click in a pivottab
 

No, you can't control the output when you double-click on a pivot table
cell. You'll get all the columns from the source data.

Juan Carlos wrote:
When I double click in a field from a pivot table excel generates a new
worksheet with all rows containing the information I choose, but it also
includes all columns from the database to which the pivot table is refering
to. Is there a way to choose just the columns I need?

Excel version 2003


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html