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
Bookmarks