Excel cannot access BloombergUI.xla. The document may be read-only or encrypted.

Excel cannot access BloombergUI.xla

Issue description:

When you launch Microsoft Excel 2016 you get below error message:

‘BloombergUI.xla’ cannot be accessed. The file may be corrupted, located on a server that is not responding, or read-only
Excel cannot access ‘BloombergUI.xla’. The document may be read-only or encrypted.
Excel cannot access BloombergUI.xla
Excel cannot access BloombergUI.xla

When Excel is Opened -> Bloomberg Tab -> When you click on Refresh then below error is displayed:

Excel cannot access BloombergUI.xla

Troubleshooting

For troubleshooting this issue, you can perform below steps:

  • Make sure C:\blp and its subfolders are excluded from Anti-virus Scanning. For SentinelOne, Add the folder to exclusions in Interoperability mode as shown below:
Excel cannot access BloombergUI.xla
  • Exclude c:\blp folder from Windows Defender Scanning using below commands on PowerShell window on the affected system.
Add-MpPreference -ExclusionPath "C:\blp"
Add-MpPreference -ExclusionPath "C:\blp\*"
  • Use setpermissions.exe to set the correct permissions on Bloomberg folders and bloomberg registry keys. Run this exe as administrator it automatically checks and fixes the permissions for you.

Launch setpermissions.exe as administrator

Excel cannot access BloombergUI.xla. BLP Permissions
Excel cannot access BloombergUI.xla. BLP Permissions
Excel cannot access BloombergUI.xla. BLP Permissions
Excel cannot access BloombergUI.xla. BLP Permissions
Excel cannot access BloombergUI.xla. BLP Permissions
Excel cannot access BloombergUI.xla. BLP Permissions
Excel cannot access BloombergUI.xla. BLP Permissions
  • Click start -> Bloomberg folder -> Install Office Add-Ins to add the Add-ins to the profile.
  • Search Bloomberg API Diagnostics in start menu and run it. Start the diagnostics and check if there are any issues – > fix the issues by clicking on Repair.
Excel cannot access BloombergUI.xla. BLP Permissions

Repair has been completed now. You should try again to see if the issue has been resolved now.

Excel cannot access BloombergUI.xla. BLP Permissions

Leave a Comment