Forum Discussion
Show report Filter Pages
Hi.
I am having a problem with generating multiple worksheets based on the filter in a Pivot Table.using the same files (.xlsx) on two different machines with two different installation of Excel 2016, it works in one, but in the other machine , under Pivot Table-Analyze_Options the Show Report Filter Pages is greyed out .Help needed.
13 Replies
Hi francesco,
Show Report Filter Pages is greyed if creating your Pivot Table you add your data to Data model.
Please check in File->Options->Advanced->Data the "Prefer the Excel Data Model..." is disabled. Or creating Pivot Table disable "Add this data to the Data Model" in Pivot Table creation window.
If you change above that won't affect already created Pivot Tables.
I am also facing the same issue after clicking >option >Data> then uncheck the prefer the excel data model when creating Pivot Table.
But I am using Excel 2016.
Advise if u can.....
In settings is only default behaviour, you may always change the option creating the PivotTable
- Hi Sergei, Am having same issue but looking into File->Options->Advanced->I don't see a Data section to be able to go to the "Prefer the Excel Data Model..." is disabled. Or creating Pivot Table disable "Add this data to the Data Model" in Pivot Table creation window
