I have a pivot table with line items that only show the "collapse" button
because they do not contain any information to show the "expand" button. Does
anyone know why the "collapse" button appears when there is no data to expand
or collapse? Can this "collapse" button be turned off without turning off
those other items in the Pivot Table that do need the "expand/collapse"
buttons showing? The Show/Hide Buttons under Options Ribbon is a toggle that
turns all of them off or on so that doesn't work for this purpose.