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