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 that you have read and understand our privacy policy and code of conduct.

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