Hi All,

Well, I have been searching and yet to find a solution. I have a pivot table with Field ("Year"), which has Items 2012, 2013, 2014...all year data is in the cache and I need it in the cache for another pivot. However, for this particular pivot I do not want 2014 to be selectable. I need both 2012 and 2013 to be able to be selected, but not 2014.

I assume that I need a worksheet VBA routine that hides 2014? Any suggestions?

Thanks!
Matt