Hi Everyone,

I have been reading and testing some of the options promoted in this forum but have not helped yet. I'm wondering if anyone knows/have a code in order to update multiple pivot tables with an external source data. The process is that i have already an excel report produced on a daily basis downloaded in my local machine, the name of the file will always be the same and in this report there is a tab containing the source data that i need. By the other hand i have another excel file with 20 pivots and slices with different views of the information so right know what i do is go to change source data -> external data source and i choose the location and sheet of the daily file.

I have tried to extract the code by running a macro but looks like the code is hidden. Any hints to have a VBA code to make the update at once? Really much appreciated. Thanks

Miguel