Slicers and corresponding pivot tables not updated on "refresh all" when using calculated columns

[Deebs2]

I have a workbook with two data connections containing three slicers connected to four different pivot tables, but neither the slicers nor the pivot tables are updated on "refresh all". I will explain what I've been able to deduct so far:


I have two data connections to SharePoint, one adding a table to the data model with the contents of a SharePoint list and the other adding a Taxonomy table to the data model with the different ID's for the possible field selections of the lists with their friendly names.

In the table with the data from the SharePoint list I have added three calculated columns with the "lookupvalue" function in order to get the friendly names from the taxonomy table.

The three calculated columns have been added as slicers connected to the pivot tables.

When I "Refresh All" data connections, the slicers and pivot tables are NOT updated. However, if I only refresh the data source with the SharePoint list (thus refreshing the table containing the three calculated columns) the slicers and pivot tables ARE updated.

The strange thing is that if I enter the data model (by clicking on "manage" in the powerpivot ribbon), I can see that the calculated column has indeed been updated when I have clicked "refresh all", but it is as if it hasn't carried throught to the workbook.

As a side note, I have the same issue regardless if I do the data connection refresh from the Excel workbook, the PowerPivot window or via VBA macro: when I do "refresh all" the slicers and pivot tables are not updated, but if I only refresh the one data connection they are.

Also as a second side note, if I remove the slicers from the workbook, the pivot tables do refresh when I do a "refresh all".

Please help!

 

[Deebs2]

As an addition to the description above:

I have been trying out some more different things. If I first "refresh all" and then refresh ANY of the two tables individually, the slicers and pivot tables will all update in the workbook. (but they will not update if I "refresh all" twice)

Also, if I first "refresh all" and then right click any of the objects (slicers or pivot tables) in the workbook and click "refresh", then all of the slicers and pivot tables will be updated.

 

[scottsen]

Excel 2010, or Excel 2013?

 

[Deebs2]

2013

 

[scottsen]

Hrm. I asked cuz 2010 was a bit weirder (you had to refresh power pivot, then refresh the reports). I get the vibe you are using Refresh All on the excel data ribbon, what if you refresh all from the Power Pivot window?

 

[Deebs2]

It's the same, regardless if I refresh from the excel ribbon, the Power Pivot window or via VBA macro ("ActiveWorkbook.RefreshAll")