PIVOT TABLE AUTO UPDATE ISSUE

riyaz · Jan 14th 2021

[xpost][/xpost]

Hello!!!

Would appreciate if someone could help me out in this unusual issue in Pivot Table.

My Pivot Table does not update/refresh automatically once I change/edit anything in the source sheet.

It was OK past few days, but I think something has gone wrong in it.

Kindly let me know if there is anything that I should do [a formula or something]

At present I manually refresh it everytime I change/edit the source sheet and it is very tedious.

Thanks,

Riyaz.

**alansidman** · Jan 14th 2021

**royUK** · Jan 14th 2021

Code

Sheet1.PivotTables("pivot table name here").PivotCache.Refresh

Where is the PivotTable, if it is on a different sheet to the data, which is the best way, then use the worksheet activate event

Code

Private Sub Worksheet_Activate()
Me.PivotTables("pivot table name here").PivotCache.Refresh
End Sub

Participate now!