I have mutiple pivot table in 1 sheet, which are also linked to pivotcharts.
How can i have excel auto-fresh when i add columns / rows to my main data source?
I want to avoid changing the data source for each pivot table manually.
have tried using below VBA formular
But when i refresh, my pivot table still does not shows the newly added pivotchart fields.
How can i have the pivotchart field show on all pivotcharts?
VBA as below, is something wrong?
**Private Sub Worksheet_Change(ByVal Target As Range)
‘Only Refresh All Pivot Tables
For Each pc In ThisWorkbook.PivotCaches
pc.Refresh
Next pc
End Sub**
Lynette Yeo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.