| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refreshing Multiple Pivot Tables at once?
Hi,
I have a worksheet with 10 PT's in, but have to refresh each table when the source data changes. Is there a way I can refresh all the PT on the worksheet at once? Thanks in advance, AW |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refreshing Multiple Pivot Tables at once?
It is easy to do with a macro. It just requires this one line of code...
ThisWorkbook.RefreshAll -- HTH... Jim Thomlinson "ArcticWolf" wrote: Hi, I have a worksheet with 10 PT's in, but have to refresh each table when the source data changes. Is there a way I can refresh all the PT on the worksheet at once? Thanks in advance, AW |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refreshing Multiple Pivot Tables at once?
Perfect, just what I needed :)
Thanks for the swift reply Jim "Jim Thomlinson" wrote: It is easy to do with a macro. It just requires this one line of code... ThisWorkbook.RefreshAll -- HTH... Jim Thomlinson "ArcticWolf" wrote: Hi, I have a worksheet with 10 PT's in, but have to refresh each table when the source data changes. Is there a way I can refresh all the PT on the worksheet at once? Thanks in advance, AW |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refreshing Multiple Pivot Tables at once?
You can also open the External Data toolbar, and click the Refresh All
button, to update all the pivot tables and external data in the active workbook. ArcticWolf wrote: I have a worksheet with 10 PT's in, but have to refresh each table when the source data changes. Is there a way I can refresh all the PT on the worksheet at once? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refreshing Pivot Tables | Excel Discussion (Misc queries) | |||
| When refreshing pivot tables my pivot table chart type changes | Excel Discussion (Misc queries) | |||
| Refreshing Pivot Tables | Excel Worksheet Functions | |||
| pivot tables not refreshing correctly | Excel Worksheet Functions | |||
| Refreshing multiple pivot tables | Excel Discussion (Misc queries) | |||
Linear Mode
