I have a file that has several tabs that have pivot tables that are based on one data tab. I am able to write the data to the data tab without issue, but I can't figure out how to get all of the tabs with pivot tables to refresh.

If this can be accomplished with openpyxl that would be ideal.

I had the same issue and was able to update my pivot table by doing the following:

from openpyxl import load_workbook
wb = load_workbook("sample.xlsx")
pivot_sheet = wb["pivot tab name"]
pivot = pivot_sheet._pivots[0]
pivot.cache.refreshOnLoad = True