Cannot set cell value used by a pivot table as a filter value
Created originally on Bitbucket by Jason Yung
Hi, I’m trying to programmatically set a filter value for a pivot table by setting the corresponding cell value.
Here’s what my worksheet looks like:
Here’s the gist of my code:
# modify the filter value on the worksheet through the cell
worksheet["B1"].value = 3
The value remains (All)
after I save and open the workbook again in Excel
Is this not the proper way to accomplish my goal?