I found https://support.microsoft.com/en-us/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2#ID0EBBF=Web, which says:

enter image description here

However, I don't see the PivotTable Tools on the ribbon, even after clicking in my PivotTable:

enter image description here

1 Answer 1

  1. Click on the pivot table.
  2. Click on the PivotTable in the ribbon.
  3. Click on Settings in the ribbon.
  4. Scroll down in the settings.
  5. Check "Refresh data on file open":

enter image description here

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.