My team inherited a pivot that does this.
Workbook uses multiple SQL statements to populate multiple pivots on multiple tabs.
The pivots are linked using slicercache. The "controlling" pivot has a larger list than the destination pivot.
On the original/unmodified workbook, when the...