I have a pivot table report and when it's printed the top just shows "Multiple Items" for a particular field's filter. I'd like to be able to print the specific list of what's selected and (more importantly) what's not. I want to create a cell to print the values, maybe comma separated, and then lock the sheet down so that when users print the report and tell me "These numbers are wrong, they don't reconcile to my other report!" I can say "That's because you filtered out X, Y, and Z." I have a feeling this involves VBA so I'm posting it here. I'll just have one specific field I want to do this for so I can reference it by name. I won't have to do this for a dynamic list of fields or anything. Can someone help me out with this?

Thanks!