On the first start of Excel after installing an Invantive Control for Excel upgrade an error may display:
Could not add XLAM to the list of add-ins.
There is no active Protected View Window.
Invantive Control functions
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32 aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.AddIns.Add(String Filename, Object CopyFile)
at Invantive.Producer.Control.Utility.FirstTimeInstallExcelUdfs(GlobalState owner, ExecutionOptions executionOptions, Boolean askFirst, String desiredXlamName, String desiredActiveXlamFilePath) in Invantive.Producer.Control\Utility.cs:line 5546
Upon first start of Excel after an installation and/or upgrade Invantive Control for Excel will complete the installation by executing a number of post-installation steps. This includes installing and activating a XLAM-file named “Invantive Control functions.xlam”.
Note that Invantive Control for Excel consists of two add-ons. Besides the xlam, the other is “Invantive Control for Excel” (filename
It is currently unclear why Excel decides to throw the error “There is no active Protected View Window” when adding the XLAM-file which activates the Invantive Control for Excel-formulas. Google search results suggest a link with SharePoint.
The recommended solution steps are:
- Restart the device or terminate all running EXCEL.EXE processes of all users on the device.
- Start Excel from the Start menu without opening a document.
- Wait one minute for Excel to start and Invantive Control to complete it’s post-installation steps.
In case the Invantive Excel add-in is missing after restarting Excel, we recommend to execute the steps in Excel no longer displays Invantive Control ribbon.
Please add an answer with the steps executed and the last error in case the recommend solution steps nor the reactivation of the Excel add-in don’t provide a solution.