HI,

I am programmatically(Using Vb.net language) creating pivot table from external data source(Access Database with Oledb provider) by using query. I saved that pivot table. I am Updating Query of pivot table in workbook open event but it is not updating pivot table.even it is not showing already saved pivot table.It is opening data source connection wizard.
I am used access database for creation of pivot table.

PLz ,Help in this regards..........if u want more information i will give it....