Change Pivot table data from dropdownlist

**dare2join** · 12-05-2012, 04:25 AM

Hi all,

Attached is the example of my pivot table.
i have 3 pivots in one sheet.
there is a column filter "Date"
is it possible to change either one of the dropdownlist and reflect the changes to all 3 pivots?

thanks!

Book1.xlsx

**AB33** · 12-05-2012, 04:36 AM

From my memory, you can create a link with slicers

**MarvinP** · 12-05-2012, 04:37 AM

Hi dare2join,

I did a problem like this a while back. Here it is attached. See if it helps. If you change the filter for any of the 3 pivots it changes the others.

**MarvinP** · 12-05-2012, 04:38 AM

I think the Slicer tool arrived with 2010 and the question is with 2007.

**AB33** · 12-05-2012, 04:42 AM

Marvin,
Thank you for spotting my error!
I did not see the OP's excel version. Infact, it is a power pivot

**dare2join** · 12-05-2012, 05:17 AM

hi,
i found something very useful from the web.
which it solved my problem here.
sorry that i post a question which i am able to solve by myself.

Please Login or Register  to view this content.

Change Pivot table data from dropdownlist

LinkBack

Thread Tools

Rate This Thread

Display

Change Pivot table data from dropdownlist

Re: Change Pivot table data from dropdownlist

Re: Change Pivot table data from dropdownlist

Re: Change Pivot table data from dropdownlist

Re: Change Pivot table data from dropdownlist

Re: Change Pivot table data from dropdownlist

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions