I solved my problem differently. Since my PivotTable was actually a tabular format, I instead filled-up a table object with formulas so I could apply slicers and have the data refreshed automatically. Thanks everybody!