Pivot Table Data Automatic Refresh

[mianmazher]

Hi All Excel Experts

I have made a pivot table using multiple consolidtion across multiple sheets


I want the pivot table data to be refreshed automatically when some thing is changed /altered in ant of the sheets.


Can It be done ?


If so Plz Help.


Regards


Mian Mazher

 

[mianmazher]

Hi Mr Excel forum Experts

Me still waiting for some one to reply


Plz help


Regards


Mian Mazher

 

[mikeprice53]

Try using a method similar to this:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Sheets("Sheet2").PivotTables("PivotTable1").PivotCache.Refresh
End Sub

Use a Screen updating Method If you want for it to run faster but note if you have a lot of data in there it will be doing one heck of a lot of work !

 

[mianmazher]

I dunno abt the VBA coding so plz help me.


Regards


Mian Mazher

 

[mikeprice53]

In Excel Hit Alt + F11 and add that code to the ThisWorkbook VBA sheet.

Have your data in sheet1 and your pivot table you have created in sheet2, if you want to rename your sheets be sure to rename them the code where you see Sheet1 and Sheet2 for the code to run, it is very simple code as I do not profess to be a wizard but it should do what you are asking from it !

good luck ! If you are still struggling just post back my friend !