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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filter with double-click	jean	Microsoft Access	1	4th Oct 2010 02:39 PM
double click in Pivot	=?Utf-8?B?QXZvaWQgRG91YmxlIENsaWNrIEluIFBpdm90?=	Microsoft Excel Misc	1	4th Apr 2007 10:16 PM
Click on graph bar to execute a double-click in a pivot table cell	Bill_F_Lyle@fpl.com	Microsoft Excel Charting	4	3rd Aug 2005 01:37 AM
double-click in between two rows or two columns	Ben	Microsoft Excel Misc	1	12th May 2004 03:35 PM
double-click in between two rows or two columns	Ben	Microsoft Excel Worksheet Functions	1	11th May 2004 09:57 PM