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
Bookmarks