PowerPivot Retain items deleted from the data source section "disabled"
Question
Monday, April 21, 2014 3:08 AM
When I try and refresh data in my powerpivot it still retains old data. I have followed the instructions on how to delete old data by doing the following:
Right click a cell inside the PowerPivot Table
Click PowerPivot Options
Click the Data Tab
In the "Retain items deleted from the data source section" select "None"
However, my problem is that this option is greyed out/disabled and I am not able to select anything here. The default is on "Automatic" but I would like to set it to "None" but why is this greyed out?
Please Help. Thank you
All replies (3)
Tuesday, April 29, 2014 2:56 PM ✅Answered
I believe the option is grayed out because it is not available for PivotTables backend by PowerPivot.
This option applies to regular excel pivot tables.
Are you seeing the old data in your PowerPivot model and the actual PivotTable after you refresh?
Tuesday, April 29, 2014 4:44 PM ✅Answered
Mike is right. For a PivotTable with a "non-PowerPivot" data source the options "Save source data with file" and "Retain items deleted ..." are available:
If the data source is PowerPivot then already "Save source data with file" isn't available, because the source data = PowerPivot is always stored in the workbook. And because of this the other "data source" related option is also disabled:
Olaf Helper
Tuesday, April 29, 2014 12:16 AM
Any suggestions for Ladeko?
Thanks!
Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!