First I apologize for being very new to VBA. I have two workbooks that need to stay separate. There are 4 data sources in one of the workbooks and the other workbook has several pivot tables that reference them. Each week, I need to save a new file with that week's name. Every time I do this, I need to go into the second workbook and update the pivot table sources to look for a file with the new week name. It's such a simple task but doing it for 50 pivot tables gets tiring. Does anyone know of VBA that can update all the pivot table sources (from the correct data source in the original workbook)?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA to change multiple pivot tables from multiple sources
- Thread starter murray32
- Start date
-
- Tags
- macro pivot pivot table source data vba
