title: Refresh all pivot tables in excel spreadsheet when data changes
body: <p>Does anyone know the VBA code to automatically refresh all Pivot tables (2 sheets that each hold 4 pivot tables) when data in the Excel (2010) spreadsheet is changed? It can also search for change in a specific cell.</p>
  
  <p>Any advice is welcome!</p>