I have a PowerPivot report created in Office 2010. I just upgraded to Office 2013 and now I'm getting the following error:

I have no idea how to fix this. There are about 30 pivot tables that are tied to PowerPivot and use the MR_Desc as a filter.



Hi,

Based on the error, this issue might be caused by following reason: In the pivot table there is some normal filtering/slicer filter done with specific values that do no longer occur in the dimension attribute mentioned

In the example error shown above : you need to look for a pivot that uses dimension attribute "[CustomerInvoice].[CustClassificationId]" ...in the list of CustClassificationIds  the " ....(a value).... " will no longer exist

Method: 'Clear the filter' and then refresh again.

Reference:

http://excelpivotanalysis.blogspot.com/2014/01/error-when-refreshing-pivot-table.html

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If you need more help about this issue, I recommend you post the question to PowerPivot forum:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpivotforexcel

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 5 hours 27 minutes ago

Hi,

Based on the error, this issue might be caused by following reason: In the pivot table there is some normal filtering/slicer filter done with specific values that do no longer occur in the dimension attribute mentioned

In the example error shown above : you need to look for a pivot that uses dimension attribute "[CustomerInvoice].[CustClassificationId]" ...in the list of CustClassificationIds  the " ....(a value).... " will no longer exist

Method: 'Clear the filter' and then refresh again.

Reference:

http://excelpivotanalysis.blogspot.com/2014/01/error-when-refreshing-pivot-table.html

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

If you need more help about this issue, I recommend you post the question to PowerPivot forum:

https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpivotforexcel

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Tuesday, August 04, 2015 2:02 AM

I already followed this. Each pivot table has multiple filters. Deleting, modifying etc. the filters throws the same error and the pivot does not change. The dimensions haven't changed. Something with Office's conversion from 2010 to 2013 broke something. I took the file and tested it in 2010 on someone else's machine and it worked. Then I performed the conversion and it stops working. I posted to the PowerPivot forum as you suggested.