Collapse/Expand Buttons in a Pivot Table

C

CindyC3

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expand/Collapse in Pivot Tables 2
Pivot Table Expand Collapse not showing for Cube 2
Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes 0
Dates In Excel 5
Expand Collapse Buttons 0
How to collapse Pivot table + icon 1
Doughnut Chart linked with the slicer in the pivot table 0
expand and collapse 1

Top