Change external data source for multiple pivots at the same time

[devolark]

Hi. I have 6 tabs with pivot tables. They are all attached to the same external excel file. Each day I need to reassign the pivot source to a new file. ie 080112 file.xls to 080212 file.xls.

I don't want to have to change data source for each pivot one at a time. Can I make the change using a macro? The number of pivots will grow so I am hoping I can find an answer.

Thanks,

Craig