Hi,

For people who use excel xp pivot tables with olap.

How do you handle requests like making only certain items
visible?

Like in my pivot table I have months with sales units and
I want just to show the current month instead of all
months. The VBA code to make a pivot item's visible
property to FALSE doesnt work for me.

Any other workarounds (other than hiddenitemlist
function)?

Thanks!!