Pivot Table Corruption


When pivot tables are dynamically updated using your component, the
pivot table produced looks correct but is internally corrupt in some
way. I suspect this might have to do with the InsertRows() and
DeleteRows() methods.

I’ve attached the workbook produced by your component. Try and
interact with the pivot table and you’ll get the following error:

“This pivot table is invalid.”

Refresh the data and the error goes away.

Thanks, Natan.


Hi Natan,

You only need to right-click the pivot table and choose "Refresh Data". Then you will find all work fine now.

To avoid this extra step, you can right click the pivot table in your template file, and choose "Table Options"->"Data Options"->check "Refresh on open".


Thanks. That worked great!