auto refresh pivot table

[DB73]

Hi peeps,

im tryin to put a code on the sheet with my pivot table but it aint working
can someone help me out
i put this code on the sheet with the pivot table but when my dump table (othe sheet) is updated its not refreshing the pivot table (table uren)

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("tabel uren").PivotTables("PivotTable6").PivotCache.Refresh
End Sub

 

[Jimmypop]

Hi there...

Have you tried...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
   Worksheets("tabel uren").PivotTables(6).PivotCache.Refresh
End Sub

 

[DB73]

Hi there...

Have you tried...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
   Worksheets("tabel uren").PivotTables(6).PivotCache.Refresh
End Sub

yes...didnt work also

 

[Jimmypop]

And you have made sure that all references to the table, sheet, pivot table are all the same (thinking also make sure everything is in the correct case...

 

[DB73]

And you have made sure that all references to the table, sheet, pivot table are all the same (thinking also make sure everything is in the correct case...

i think so

 

[Jimmypop]

Try...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("tabel uren").PivotTables("Draaitabel6").PivotCache.Refresh
End Sub

 

[DB73]

Try...

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("tabel uren").PivotTables("Draaitabel6").PivotCache.Refresh
End Sub

doest work also ....but when i do refresh manually then excel start freeking out...after a while i get this;

method refresh of object pivotcache failled

problem;