I'm trying to help a friend figure out an excel file for work.
We have a file with a variety of tabs and in those various tabs are various pivot tables. Let's say the file name is october sales. However for some reason all of the pivot tables are pulling data from the september sales file. Is there a way we can write a VBA code to have all pivot tables in all tabs pull from the october sales file instead of september? I've read many forums about how to refresh data all pivot tables, etc... However, none can tell me how to change source data.
We have a file with a variety of tabs and in those various tabs are various pivot tables. Let's say the file name is october sales. However for some reason all of the pivot tables are pulling data from the september sales file. Is there a way we can write a VBA code to have all pivot tables in all tabs pull from the october sales file instead of september? I've read many forums about how to refresh data all pivot tables, etc... However, none can tell me how to change source data.
