Hi Peter, Thank you for the response. I did try your suggestion but it didn't work.Welcome to the MrExcel board!
Try selecting a cell in the Pivot Table then right-click & choose 'Pivot Table Options...'
On the 'Display' tab there should be the option to 'Show expand/collapse buttons'
View attachment 121884
I am using 365 version, i don't know if it the same functions as yours, but it is where I found the show expand/collapse buttons options. I right clicked on one of the cells. Didn't see the options so i clicked on settingsYour image is different to mine so there must be something different about your data or Excel version to mine or else you are looking in a different place? I'm not sure.
Pretty hard to try to recreate what you have from an image, especially one so tiny so I have probably not replicated your situation.