ExcelBanter - Updating numerous Pivot Tables in a Workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Updating numerous Pivot Tables in a Workbook (https://www.excelbanter.com/excel-programming/394974-updating-numerous-pivot-tables-workbook.html)

John

Updating numerous Pivot Tables in a Workbook

Hi all,

I run a consolidation process which creates a table of information which i
then manually refresh 6 Pivot Tables. Programmatically is this possible
please, and if so where would i start?

Thanks
John

Tom Ogilvy

Updating numerous Pivot Tables in a Workbook

workbooks("Data.xls").RefreshAll

--
Regards,
Tom Ogilvy

"John" wrote:

Hi all,

I run a consolidation process which creates a table of information which i
then manually refresh 6 Pivot Tables. Programmatically is this possible
please, and if so where would i start?

Thanks
John

John

Updating numerous Pivot Tables in a Workbook

That simple huh :) Thanks Tom!

"John" wrote:

Hi all,

I run a consolidation process which creates a table of information which i
then manually refresh 6 Pivot Tables. Programmatically is this possible
please, and if so where would i start?

Thanks
John

All times are GMT +1. The time now is 03:38 PM.