Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing multiple pivot tables
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? -- jerredjohnson ------------------------------------------------------------------------ jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236 View this thread: http://www.excelforum.com/showthread...hreadid=519918 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables are Automatically refreshing | Excel Discussion (Misc queries) | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
How do I keep file sizes small when using multiple pivot tables? | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions |