Possible #powerpivot issue removing Excel 2016 going back to Excel 2013
Today I observed an issue on a notebook where Excel 2016 was installed and then removed, going back to Excel 2013.
After this operation, workbooks having a Power Pivot data model were working correctly by navigating data in PivotTables, but any operation in the Power Pivot window (such as adding columns, tables, or editing measures) was failing. The error was a TYPE_E_CANTLOADLIBRARY and it was caused by a type library not removed uninstalling Excel 2016.
Tags: excel