Pivot tables are amazing to hand off to competent users to let them poke around at their data, but sometimes I would not want them to swap rows and columns beca

Pivot tables are amazing to hand off to competent users to let them poke around at their data, but sometimes I would not want them to swap rows and columns because it would wreck some calculation I was doing. So, I used some vba to lock down the certain functionality. I think this page has some of the techniques I used: https://spreadsheetplanet.com/lock-pivot-table-excel/ https://spreadsheetplanet.com/lock-pivot-table-excel/