Show Filter Reports

[mwhens]

Hi
When in a pivot table and I show filter reports, the new sheets are not renamed according to the filter, but merely sheet 3, sheet 4 etc

 

[Alex Blakenburg]

This was unresolved in a much older post (2013)

Pivot Tables- "Show Report Filter Pages" does not name new worksheets with "filter name"

When I select "Show Report Filter Pages" from the Pivot Table Tool Options, it creates new worksheets from the filed I have in the filter, but it it just names them Sheet 2, Sheet 3, Sheet 4, etc. The documentation states that each worksheet will be named after each customer, dept (whatever the...

www.mrexcel.com

I am unable to reproduce the issue. I would need to see at least a picture of the pivot filter with the drop down box expanded, I usually use <windows>+<shift>+S, to capture open drop down boxes.
Also a picture of the source data sheet.

 

[mwhens]

Resolved: There was data with more than 35 characters.

thank you