Hi Experts,

Any help is really appreciated. It is a straight forward situation.

I have file I am manipulating to create pivot tables, my manipulated file needs to update when ever the parent file updates and also my pivot tables should update.

I dont know how to write VBA code. Is there an example with which I can change a few simple things and get it done.

The Parent file is located on a common drive and I have made a local copy of this and manipulated it to get an excel spread sheet.
Now I use this sheet to create pivot tables and generate a report for the user.

So how do i link these files.

Please suggest. thanks in advance