Forum Discussion

Deleted

Apr 02, 2017

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 201...

excel

SergeiBaklan

Diamond Contributor

Apr 03, 2017

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.

ashar1986

Copper Contributor

Sep 28, 2019

SergeiBaklan

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

SergeiBaklan
Diamond Contributor
Sep 28, 2019
ashar1986

In settings is only default behaviour, you may always change the option creating the PivotTable
- ASanford
  Copper Contributor
  Nov 17, 2020
  SergeiBaklan The option is still not available for me. Is there another step I can try?
  - SergeiBaklan
    Diamond Contributor
    Nov 17, 2020
    ASanford
    
    Do you have any filters applied to PivotTable?
    
    Plus, even if setting is off, you have possibility to add data to data model on very first step of PivotTable creation. Just check you have no data in data model.