However, I don't see the PivotTable Tools on the ribbon, even after clicking in my PivotTable:
- Click on the pivot table.
- Click on the PivotTable in the ribbon.
- Click on Settings in the ribbon.
- Scroll down in the settings.
- Check "Refresh data on file open":
No idea how to automatically refresh a pivot table in Excel 365 (web) more frequently than just on file open. If anyone knows, please add another answer.