I have a workbook with multiple pivot table tabs linked to a db.
I am making this project for each customer, so when i have a new customer i copy the workbook and go back to pivottable wizard step 2(get data) to change the customer. this refreshes the first sheet with the new customer info but not the rest of the tabs. is there a way to refresh all sheets instead of re-creating each tab off of the first one?
Bookmarks