Useful IBM Planning Analytics for Excel (PAFE) Batch Scripts

Force close both Excel and PAFE:

taskkill /f /im excel.exe
taskkill /f /im CognosSessionMonitor.exe

Disable ALL add-ins from Excel startup:
Assumes PAFE is one of these, and works up to 10 add-ins.

REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN1 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN2 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN3 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN4 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN5 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN6 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN7 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN8 /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v OPEN9 /f

Unlink PAFE add-ins from Excel:

REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins\CognosOffice12.Connect" /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins\CognosOffice12.ConnectPAfEAddin" /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\Addins\IBM Planning Analytics for Excel Addin (Custom Task Pane Helper)" /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\AddinsData\CognosOffice12.Connect" /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\AddinsData\CognosOffice12.ConnectPAfEAddin" /f
REG DELETE "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Excel\AddinsData\IBM Planning Analytics for Excel Addin (Custom Task Pane Helper)" /f

Reset all PAFE settings:

rmdir "%APPDATA%\..\Local\Cognos\" /q /s

Set Excel Option > Optimize for compatability

REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v "RenderForMonitorDpi" /t "REG_DWORD" /d "0" /f

Set Excel trusted location for location of PAFE.xll file

:: Needed only for network locations:
REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations" /v "AllowNetworkLocations" /t "REG_DWORD" /d "1" /f

:: How to set actual trusted location:
REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations\Location999" /v "AllowSubfolders" /t "REG_DWORD" /d "1" /f
REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations\Location999" /v "Date" /t "REG_SZ" /d "1/1/2020" /f
REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations\Location999" /v "Description" /t "REG_SZ" /d "description_goes_here" /f
REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Security\Trusted Locations\Location999" /v "Path" /t "REG_SZ" /d "path_goes_here\" /f

Connect Excel to IBM PAFE Add-In:

REG ADD "HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options" /v "OPEN" /t "REG_SZ" /d "/R path_goes_here /f
Scroll to Top