Hi,

I would like to know if it is possible to automatically load, once exported to, specific data into a pivot table. To explain a little better, I am exporting data from a Sharepoint site, from this I am creating a pivot table although I need the pivot table to be a specific tempalte and load only specific fields. In addition to this, I would like macro's/formula's I have created to load also.

Unfortuantley, I cannot refresh the Data in the Pivot table so every two weeks I run the same export but I have to manually select the fields I require and re write my formula and macro's.

Bit of a shot in the dark but hoping someone can point me in the right direction? I expect I will need to use some Advance VB or something?

I appreciate any assistance,

Kind Regards