Pivot Table Refresh Not Working

I have a Pivot Table which is not getting refreshed when there is a change in no. of rows in the data source. I have a table as a data source, so whenever the rows got increased or decreased in the t...

excel

HansVogelaar
Aug 01, 2022
learnerjane

Thanks, I received your PM.

Your pivot table is filtered to display only data for HDL File Name = Contact.dat.

I disabled the Worksheet_Change event procedure, then deleted one of the Contact.dat rows.

Refreshing the pivot table from the PivotTable Analyze tab of the ribbon worked as expected.

I also added a new row to the source table with HDL File Name = Contact.dat. Again, refreshing the pivot table from the ribbon worked correctly.

Is it possible that you added/deleted rows for other HDL File Names? The pivot table wouldn't change as long as it is filtered on Contact.dat

HansVogelaar

MVP

Aug 01, 2022

learnerjane

Thanks, I received your PM.

Your pivot table is filtered to display only data for HDL File Name = Contact.dat.

I disabled the Worksheet_Change event procedure, then deleted one of the Contact.dat rows.

Refreshing the pivot table from the PivotTable Analyze tab of the ribbon worked as expected.

I also added a new row to the source table with HDL File Name = Contact.dat. Again, refreshing the pivot table from the ribbon worked correctly.

Is it possible that you added/deleted rows for other HDL File Names? The pivot table wouldn't change as long as it is filtered on Contact.dat

learnerjane

Copper Contributor

Aug 01, 2022

My bad. I totally missed it. Thanks Hans.

Forum Discussion

Pivot Table Refresh Not Working

Resources