0
Is there a way in Excel to paste in multiple items as pivot table filters? If I have a list of 15 codes out of a larger set of possible values, it's tedious and error-prone to scroll around to find the ones I'm interested in.
There is an add-in that works on SSAS sources that lets you paste in a list of entries but it doesn't work on local pivot sources.
Jeff Sacksteder
Posted 2013-06-12T18:20:54.250
Reputation: 261
No, it's a generalized problem that I am simplifying here. It's never the same subset from day to day. – Jeff Sacksteder – 2013-06-12T19:10:05.563
2010 in this case. – Jeff Sacksteder – 2013-06-12T19:32:54.467