Herbert Seidenberg wrote on 02/05/2010 12:59 ET :
Excel 2007 PivotTable
GetPivotData with drop-down lists.
http://c0444202.cdn.cloudfiles.racks...02_02_10b.xlsx

thanks for this reply! You saved my life (figuratevely speaking)! I've been
searching for this solution for a few hours until I found your solution