VBA - Auto refresh Pivot Tables

Hello excellers,

I'm new to the VBA world! Trying to learn as much as possible.

At the moment, I am trying to auto refresh a pivot table every time new data is added into the original table.

This is for Excel 2011 for Mac and so far any 'code' I try to write or use just gives me a bunch of error messages or infinitely loops to the beach ball of death.

The example I posted will give a quick idea of what I'm trying to accomplish.

I want to be able to select the difference alternatives and have the pivot table change automatically when the different alternatives are chosen.

This is the script i'm using...but it doesn't seem to be working for my Apple product!

Private Sub Worksheet_Change(ByVal Target As Range)
  Worksheets("Data").PivotTables("PivotTable2").PivotCache.Refresh
End Sub

try this:

Private Sub Worksheet_Calculate()

   'If data on this worksheet changes, refresh the pivot table
   Sheets("Data").PivotTables("PivotTable2").RefreshTable
   
End Sub

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.