Hello Guys,

There is a problem, Is this possible that if we import some data of more than one tables of MS-SQL of same database to a pivot table for creating a report. Now if the data in MS-SQL will be updates then the associated pivot table's data will also automatically updates.
I means pivot table will remain synchronized with its source MS-SQL data tables for its each update automatically.

I have a clue that it may be possible by some kind of VB script but I don't know How... Plz some body help me in this that it is possible or not and if yes then HOW...

plz... HELP ME....

Thanks A Lot.