Collapse/Expand Buttons in a Pivot Table
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. |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com