The 'Refresh every x minutes' option will be available if the pivot
table is based on an external data source.

You could use programming to update the pivot table if the worksheet is
activated. For example, right-click on the pivot table worksheet's sheet
tab, choose View Code, and paste the following code:

Private Sub Worksheet_Activate()
Dim pt As PivotTable
For Each pt In ActiveSheet.PivotTables
  pt.PivotCache.Refresh
Next pt
End Sub