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