[2016-094] Pivot/ Automatically Refresh

1. Make Pivot table in your excel.

2. Rename Pivot Table Name

3.Click "Developer" tab on the ribbon. Click "Visual Basic" button.

4.Double click on your sheet in project explorer window. (left side)

Paste below code into worksheet code page to the right of the project explorer window. 

Private Sub Worksheet_Change(ByVal Target As Range) 

  Worksheets("Sheet1").PivotTables("PivotTable1").PivotCache.Refresh 

End Sub

5. Close this window.

Try to change your data in excel.

6.Save as an .xlsm.