title: How to create a list of all ticked/non-ticked filter in an excel pivot table
body: <p>This, I hope, is a really simple question but it might not be possible. </p>
  
  <p>In excel, I have used multiple filters in a pivot table, I now want to create a list of the options ticked from the various filters.</p>
  
  <p>How can I create a list/copy all the ticked (or un-ticked) boxes. I have around 800 filters with about 250 boxes ticked.</p>