Forum Discussion

FranckGbadamass

Helper I

4 years ago

Solved

Help Pivot Tables caches!

Hello everyone, I'm struggling with my file. I've built a data model from PowerQuery to PowerPivot and then created a Pivot Table, but when I delete the data from the source data it still appears o...

Tips and Tricks

jennratten
4 years ago
Hello - this article explains why your option is greyed out.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/71f2c315-4ff5-4a8e-acec-d99d6caf81cb/powerpivot-retain-items-deleted-from-the-data-source-section-quotdisabledquot?forum=sqlkjpowerpivotforexcel

This article suggests checking the setting in File - Options - Data. If the "Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Connections.

https://www.mrexcel.com/board/threads/pivottable-option-to-modify-number-of-items-to-retain-per-field-is-greyed-out.487169/

This article provides the steps for removing the old items manually and automatically.

https://www.contextures.com/xlPivot04.html

Super User

4 years ago

Hello - this article explains why your option is greyed out.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/71f2c315-4ff5-4a8e-acec-d99d6caf81cb/powerpivot-retain-items-deleted-from-the-data-source-section-quotdisabledquot?forum=sqlkjpowerpivotforexcel

This article suggests checking the setting in File - Options - Data. If the "Prefer the Excel Data Model when creating PivotTables, QueryTables and Data Connections.

https://www.mrexcel.com/board/threads/pivottable-option-to-modify-number-of-items-to-retain-per-field-is-greyed-out.487169/

This article provides the steps for removing the old items manually and automatically.

https://www.contextures.com/xlPivot04.html