Pivot Table - Auto Refresh

MrExcel.com was kind enough to provide some code to include in the tab to execute an auto refresh on a pivot table. However, I am not smart enough to implement the code.

I have three tabs in my workbook.

- Raw Data sheet (the source data)
- Calculations (a sheet that has calculations of the raw data. This is the sheet that is the source data for the pivot .)
- Summary (the sheet with the pivot table)

Here is MrExcel's code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Summary.PivotTables(1).RefreshTable
Application.EnableEvents = True
End Sub

I was told to view code in the Raw Data tab and insert this code and when the data in the Raw Data tab changed it would automatically update the pivot table in the Summary tab.

It isn't working. I am sure it is "pilot error" on my part. HELP! WHAT AM I DOING WRONG?

Thanks,

MD

A simple way to make pivot tables automatically refresh is to right click on them, and choose table options, then check the box for an automatic refresh and set the frequency!