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 201...
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
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.
- tks you very much, my problem and when i see picture so i can
