| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to create multiple Pivot tables at once
"I have 14 Pivot Tables on this report that I make fairly often". .. if all PTs are based on the same data can you put the data in one sheet, "name" the range that contains the data and use that range name as the pivot table source. Whenever you change the data in the named range and refresh, _all_ the pivot tables will show the new data. -- steven1001 ------------------------------------------------------------------------ steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757 View this thread: http://www.excelforum.com/showthread...hreadid=563738 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i create multiple pivot tables with one field automatically | Excel Discussion (Misc queries) | |||
| #REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
| Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
| Pivot Tables with Multiple Lists | Excel Discussion (Misc queries) | |||
| Problems with updating category names in pivot tables | Excel Discussion (Misc queries) | |||
Threaded Mode
