In the pivot table layout dialog's "Options" expander, there are things including: 1. Enable drill to details 2. Show expand/collapse buttons It turns out that they affect each other, but that relationship is never made explicit in the UI. If you disable "Enable drill to details" (I don't know why you would actually want to do that), the expand/collapse buttons do not work even if they are shown. My main recommendation (approach A) would be to merge the two settings into only one: either you show the expand/collapse buttons when you want this thing to be drillable/collapsible, or you don't. Failing that, if you really want to preserve the ability to enable/disable drilling, then approach B would be: * Expansion/collapse "+"/"-" buttons should not be shown in the spreadsheet when drilling is disabled (because you can't interact with them anyway) * The "Show expand/collapse buttons" checkbox should be marked as insensitive in that dialog as soon as the user unchecks "Enable drill to details". As you can imagine, I'd much prefer approach A. --- Observed on Version: 25.2.0.3 (X86_64) / LibreOffice Community Build ID: e1cf4a87eb02d755bce1a01209907ea5ddc8f069 CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Flatpak Calc: threaded