This project has moved and is read-only. For the latest updates, please go here.

Error :Refresh table method of Pivot Table class failed

Topics: Resolved
May 20, 2010 at 9:30 PM


I am using the OLAP Pivot Table Extensions in excel 2007 to add calculated members to my pivot tables. It

worked fine for sometime and then it gives me the above error when I try to add or

delete more calculated members to the pivot table. Do you know of any reason why this could


It does not even allow me to add other pivot table measures to the table when this happens.

Thanks in advance for you help.




May 20, 2010 at 11:14 PM

Hmm. That is perplexing. You might start a new PivotTable from scratch and try to rebuild it to match exactly. Unfortunately Excel doesn't offer up very good error messages, so it's hard to know the problem.

Also, on the existing PivotTable which is causing problems, I would go to the MDX tab in OLAP PivotTable Extensions, copy that MDX, then send it to your OLAP administrator to troubleshoot what's going wrong.

Are there any interdependencies between the calculations you've added via OLAP PivotTable Extensions? I wonder if the sequence you add them matters.

Not sure how else to suggest troubleshooting the problem.

Marked as answer by furmangg on 6/10/2014 at 3:36 PM