Is there a code to "ShowAll" in a PivotField? I have written a code that
correctly sets the visible property of unwanted dates to False. When I
refresh the PivotTable to a new list, I must show all items to run the code
again. Every time I try to run a code to set all items to true, I get a
run-time that says I cannot set the visible property of the PivotItem Class.