Hello,

I am new to excel VBA and hope that I am posting in the right forum. I created a pivot table, without using VBA code, in which I use slicers; I did not use code to create the slicers. One of the pivot table fields is FY09. But when I click on the slicers to filter and then filter back to the original data, the field changes to "sum of FY09." Is there VBA code I can use to prevent this from happending? Or, is there a setting, without using VBA, to make this adjustment?

Thank you for your time. Slickjimmy.