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.

I solved the problem by removing the following key from the registry 

[HKEY_CLASSES_ROOTTypeLib{00020813-0000-0000-C000-000000000046}1.9]

(WARNING: DON’T TOUCH THE WINDOWS REGISTRY IF YOU DON’T KNOW WHAT YOU ARE DOING – use the following link to get more detailed instructions and always do a backup first).

I found this article that describes the problem as a possible issue in all the versions of Excel!

IF

Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE.

IF ( <LogicalTest>, <ResultIfTrue> [, <ResultIfFalse>] )