Pivot table not updating 2016
two excel files, one for German settings, the other for Ehglish.Windows 7, Excel 2010 I have inserted data on a single worksheet that populates around 10 pivot tables, each on their own worksheet. One of the members of my team left and was replaced by a different person and so rows that contained that person's name needed to be updated.What I mean by this, is that I refreshed the pivot table using the refresh button in the ribbon.I then went to the relevant pivot table field in the field list, "Project Owner" and clicked the down arrow.The only way I can get it to update is by checking the ‘Hide items with no data’ in the slicer properties. I can’t believe the slicer will not update after a data model refresh! The only work around I can think of is via VBA code to call a function on the slicer which forces a refresh eg slicer ‘Hide items with no data’ function or the slicer ‘sort order’ function which seem to force a refresh. I think it comes down to the way MSFT have implemented sheet protection.The check boxes that allow you to filter the data still offered the name of the person that left and who's name had been eliminated from the data.I also tried to do the same thing by pulling the "Project Owner" field from the field list into the report filter window subsequently attempting filter in the pivot table. Is there a way to get rid of the name of the person that had been eliminated from the original data so that I only see current data listed in the field filter?
If you add new data to your Pivot Table data source, any Pivot Tables that were built on that data source need to be refreshed.
At any time, you can click Refresh to update the data for the Pivot Tables in your workbook.
You can refresh the data for Pivot Tables connected to external data, such as a database (SQL Server, Oracle, Access, or other), Analysis Services cube, data feed, and many other sources.
Seems like the slicers are excluded from the Excel side refresh. If a user is allowed the privileges above on a protected sheet, then updating the slicer source data should perhaps follow through to the slicer?
Having said that, upon protecting the sheet the following options were ticked allowing the user to operate the slicer and have the pivot charts / tables update: I’m unsure whether this is a bug or not.