Waiting for PivotTable Auto Refresh got old, so I built a VBA tool that keeps them updated on my terms.
Select PivotTable. Choose New Worksheet for a fresh sheet, or Existing Worksheet to place it in a specific spot. Select OK. In PivotTable Fields, check field names or drag fields into Rows, Columns, ...