The Bloomberg Excel Add-In is Missing When I Open Excel

Problem

The Bloomberg Excel add-in is missing when I open Excel

Solution

Note: If someone else was logged in using Excel, it is simplest to restart the computer before beginning these steps

  1. Restart Computer
  2. Login to the computer
  3. Click Start
  4. From the Start Menu Search for Bloomberg
  5. In the right hand side of the Start Menu, select Open File LocationUploaded Image (Thumbnail)
  6. Click Install Office Add-Ins
  7. Click Install
  8. Click OK
  9. Click Close
  10. Open Excel and verify that the Bloomberg tab is on the menu bar
  11. If you receive an error, check the Task Manager for any open instances of Excel or Microsoft Office
  12. End Task on any open instances of Excel or Office
  13. From the Start menu, click Bloomberg
  14. Click Stop API process
  15. Follow the window prompts, press Enter/Go on the keyboard
  16. From the Start menu, click Bloomberg
  17. Click API Environment Diagnostics
  18. Click Start
  19. Click Yes to proceed
  20. Click OK
  21. Click Repair
  22. Wait for repair to complete
  23. From the Start menu, click Bloomberg
  24. Click Install Office Add-Ins
  25. If still having the issue try manually installing the add-in
  26. Open Excel
  27. Click File
  28. Click Options
  29. Click Add-ins
  30. From the Manage drop-down menu select Excel Add-ins
  31. Click Go...
  32. Click Browse
  33. Browse to C:\blp\API\Office Tools
  34. Select BloombergUl.xla
  35. Click Open
  36. Click OK
  37. Restart Excel

 

If you receive an error or still having an issue, please contact the Service Desk with the following information: 

  • Building name
  • Room number
  • Detailed information about the error message

Products or Services Involved

  • Beacom Finance Lab
  • Microsoft Office
  • Bloomberg Excel Add-in
  • Microsoft Excel

Cause

The Bloomberg Office add-ins are a per user installation and are not installed during the Bloomberg software installation

Need More Help?

If you receive an error or still having an issue, please contact the Service Desk with the following information: 

  • Building name
  • Room number
  • Detailed information about the error message