Friday, May 18, 2018

App-V Office Add-in fails to load. Sorry, we couldn't find.........


In some situations App-V Microsoft Office Add-ins can fail to load and also cause a particular type of error message to be generated.  This effect has been seen with COM add-ins crashing Excel at launch and failing to load in Powerpoint.  If attempts are made to activate the add-in via the COM Add-in manager, then an error can appear similar to:


Microsoft Powerpoint
Sorry, we couldn't find C:\Users\username\Application Data\Microsoft\Powerpoint\.  Is it possible it was moved, renamed or deleted?


If this occurs, evaluate the sequencing method being used and how the normal installation behaves when the Add-in is first launched with Excel or Powerpoint.  With the Mekko Graphics add-in, a license dialog is initialized at first launch.  It is this which appears to result in this type of error.

For the Mekko Graphics sequence the correct approach was to launch Excel and Powerpoint during sequencing.  Then edit the sequence to apply the following modifications:

The following keys MUST be set to Merge
MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel\Addins
MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\Excel
MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint\Addins
MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\PowerPoint
MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins
MACHINE\SOFTWARE\Microsoft\Office\Excel
MACHINE\SOFTWARE\Microsoft\Office\PowerPoint\Addins
MACHINE\SOFTWARE\Microsoft\Office\PowerPoint

The following files must be removed from the sequence
Package\Root\VFS\Common AppData\Knowledge Management\Mekko Graphics\mekko.lic
Package\Root\VFS\Common AppData\Knowledge Management\MekkoGraphics\MGConfig


The merge settings allow the add-in to co-exist with other add-in type packages that may exist in the connection group.  Deleting the license files allows "normal" operation of the add-in.  Repair / Reset works ;-)