PivotTable Option to modify number of items to retain per field is greyed out

[DarkHunter]

If I 'right-click' a cell and choose PivotTable Options. Then click the Data tab, the choice under "Retain item deleted from the data source" is Number of items to retain per field" - The choices are greyed out. What is causing this? We have Excel 2010.

 

[michaeljwilson6]

Try going to: File - Options - Data. If the "Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Connections" is checked, un-check it.