Pivot table not updating refresh Free live chat with sex workers
However, in your scenario the pivots are probably based on the data you have to refresh first.
The pivot will refresh while the data is not loaded yet, hence the unexpected behavior.
I made a list of my top 5 annoyances, and you might have other problems to add to the list.
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.
With pivot tables, it's often the little things that are frustrating..doesn't show up when you refresh, number formatting goes missing, fields have weird names...things like that.
In this short video, we look at 10 common pivot table problems 10 easy fixes.