I have a worksheet that has 4 pivot tables. These tables are all linked to the same file stored on a network drive. It is a Usage file and that file changes every week......(in week 1 file would be UsageWk1.xslx, in week 2 file would be UsageWk2.xslx......). I would like to link these 4 pivot tables so that i can update the external data sourece 1 time for all 4 pivot tables. Any way to do that?
Linking Pivot Tables on Same Worksheets all Linked to Same External Data Source
-
-
-
Re: Linking Pivot Tables on Same Worksheets all Linked to Same External Data Source
You can refresh the pivot tables each time the workbook is opened with this, placed in the Workbook Object Module
CodePrivate Sub Workbook_Open() Application.ScreenUpdating = False ActiveWorkbook.RefreshAll Application.ScreenUpdating = True End Sub
Or you could run this at any time (maybe assign it to a button on the sheet with the pivot tables)
-
Re: Linking Pivot Tables on Same Worksheets all Linked to Same External Data Source
I have to change the data source file each time i update the pivot tables to a different file, cannot do a refresh
-
Re: Linking Pivot Tables on Same Worksheets all Linked to Same External Data Source
any thoughts on this?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!