THANKS, I am new to Excel programming do have any sample,

"Tom Ogilvy" wrote:

Create each individually with the macro recorder turned on.

then use the recorded code to get the code for making each the datasource.



--
Regards,
Tom Ogilvy


"Kalyan" wrote:

Thanks Tom, situation here is, my datasource is three different SQL Server
(analysis server (AS2000)) popluating data from cubes.

Help please

Thanks
kalyan

"Tom Ogilvy" wrote:

make the datasource for your pivot table a defined name such as Database.

then just have each button redefine the range Database refers to and then
refresh the pivot table.

--
Regards,
Tom Ogilvy


"Kalyan" wrote:

is there any way to change datasource dynamically

Example.

I will three Command Button, each button refer to three data source

Button A - Production
Button B - Development
Button C - QA

based on click, pivot table will change the data source, if i press refresh
i will populate corresponding data

thanks