|
|
|
|
|
|
by jerry1979
976 days ago
|
|
|
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/ |
|
|