show report filter pages

  1. G

    Pivot table - Show Report Filter Pages - shortens tab names to 26 characters

    Hello, First time poster. Great website. I have an issue with a Pivot table. I am using 'Show Report Filter Pages' function. I ensured that the tab names that would be populated have equal to or less than 31 characters (to abide by the 31-character limit). The problem is, when I use the...
  2. W

    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...
  3. S

    2007/2010 Pivot table "show pages" option

    hi- in excel 2007 and 2010, the show pages function is not working in my pivot table. I have used this feature TONS in 2000. Any idea what the issue is? I can see the button, but it is greyed out. Background- the pivot table data source is an exernal database. thanks in advance for any...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top