Excel error related to BI plugin



I am getting a whole lot of errors in Excel related to the latest Excel update and the BI plugin. Here are 3 of them:

  • An unexpected error occurred: Object reference not set to an instance of an object
  • An unexpected error occurred: No CurrentLibrary set.
  • A problem occurred wile the add-in was creating an isolated application domain and loading required assemblies.
    • The ExcelDna.Loader assembly could not be loaded from resource.
    • Additional error information: HRESULT 0x80131014. 
    • This add-in is built with Excel-DNA and is being loaded from the following location: C:\Program Files (x86)Common Files\BIExcelFunctions1.1\32bit\Sage.BI.ExcelFunctions1.1.sll.

If anybody can please advise? This is not isolated to a single workstation of environment.