P Piotr May 16, 2005 #1 Is there any way to make Pivot Table ask for parameter of the querry before refreshing ?
E Ed Ferrero May 17, 2005 #2 Hi Piotr, You can place the parameter field as a Page Field in the Pivot Table. Then double-click the Page Field label, click Advanced, and set the options to 'Query external data source as you select each page field item' Ed Ferrero http://edferrero.m6.net
Hi Piotr, You can place the parameter field as a Page Field in the Pivot Table. Then double-click the Page Field label, click Advanced, and set the options to 'Query external data source as you select each page field item' Ed Ferrero http://edferrero.m6.net
