Hi I have couple pivot tables/charts, which I do run reports and update them using macros. For some of the reports filters do change (i have no idea why), I need the filters to by solid and not change on the pivot tables. Is there a solution out there? I used google searches but was not able to find any solutions.