PIVOT TABLE AUTO UPDATE ISSUE

riyaz · Jan 14th 2021

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

crossposted at: https://www.excelforum.com/off…te-issue.html#post5454691

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

https://www.excelcampus.com/vb…vot-tables-automatically/

**royUK** · Jan 14th 2021

http://excel-it.com/excel_vba_paste_code.htmYou can use VBA to refresh the PivotTable

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

Where to put your Excel VBA Code

Share