Applies To: HP ALM Business View Excel add-ins for ALM 12.0x and up. Note, this solution may apply to all HP ALM and Excel versions. 

(Note: Registry key path is for Windows 7)


Issue Summary: This issue was detected in HP ALM 12.53 with Excel add in 12.01 (patch 3) and newer. The mapping gui window would open and would not allow you to save the mapping. Following the save button not performing any action the ALM Excel add in mapping window would lock up and force you to kill Excel via task manager. This issue is due to Excel security settings and in this case there was a global user policy which prevented the security from being disabled in the registry although the Excel trust center settings appeared to be set correctly.


Steps to Fix:


  1. Open Excel then go to file menu --> options and navigate to the trust center settings
  2. From trust center settings select the "Macro Settings" option and ensure your settings are not configured as "Disable all macros without notification". If permissible by your security policy select the "Enable all macros" option and also select "Trust access to the VBA project object model".
  3. Test to see if this fixed your issue with the HP ALM Excel Add in not working correctly. If you are still facing issues continue with the following steps.
  4. Open start menu and in the search bar type "regedit" to open the windows registry editor
  5. Navigate to the following registry key, "HKCU\Software\Microsoft\Office\Common\Security\automationsecurity" and check the value and compare with the list below
  • msoAutomationSecurityForceDisable = 3
  • msoAutomationSecurityByUI = 2
  • msoAutomationSecurityLow = 1
  • If the value is set to 3 after modifying your Excel security settings via Excel options then this is likely your issue. Change the "REG_DWORD" value for this registry key to either 2 or 1 and then test the Excel add in once more.

If this fixes your issue and you have multiple users who need permissions changed we have created a simple VBScript that should help expedite the process.


  

Sub ModifyRegVal()
    Set WshShell = CreateObject("WScript.Shell")

    myKey = "HKCU\Software\Microsoft\Office\Common\Security\automationsecurity"
    myval = 2

    WScript.echo "Modifying value for: " & mykey
    WshShell.RegWrite myKey,myval,"REG_DWORD"

End Sub

call ModifyRegVal()