Hi,
I have a master excel file and 6 other excel files. All these 6 files have an identical table. In the master file I want to create a pivot table that connects externally to the table of the file selected by pressing one of 6 buttons. What is the best way to change the data connection properties using VBA? Is it necessary to recreate the pivot table?
Regards,
Elio Fernandes
Bookmarks