It can also relate to error XRL ERROR - MSSCRIPT.OCX.
When you get this error. You need to run a registry fix. See attached - Take a backup of the registry - open up regedit, file, export, save to c:\temp\registry. OK. Close out of regedit - Double click on the .reg and run it. This will apply the registry change to that pc - Run the the registry change on each client machine that has XRL installed - Launch Excel and login to XRL and confirm that reports can be created without encountering the VB script error - Reboot the machine The registry that get's updated is below. Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}] "Compatibility Flags"=dword:0 "ActivationFilterOverride"=dword:1 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}] "Compatibility Flags"=dword:0 "ActivationFilterOverride"=dword:1 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3742-5B07-11cf-A4B0-00AA004A55E8}] "Compatibility Flags"=dword:0 "ActivationFilterOverride"=dword:1 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3742-5B07-11cf-A4B0-00AA004A55E8}] "Compatibility Flags"=dword:0 "ActivationFilterOverride"=dword:1
If the above DOES NOT WORK and this is a TERMINAL SERVER XRL install and you have ticked the 'Application User Profiles' option in the XRL\MAINTENANCE\ABOUT screen: robocopy "%appdata%\infor query and analysis" "c:\Users\%username%\appdata\roaming\infor query and analysis" /e
|