I currently have a report that is feed by a pivot table. Each time you change the filter on the pivot table, new data comes up and alters the report. What I would like to do is be able to print a series of different reports, each with a different filter. I've tried to build a macro that would go through and select the various filters I want and print them, rather than having to manually select the filters each time I open the file. The problem I am having is that whenever I initiate the macro, it will not clear what was already selected in the report. I have various people, printing various reports and each time they print, whatever data was last loaded by the previous user is present on the new report as well. Is there a code I can write that would allow me to start with a clear pivot table each time?