Excel Add-ins not working correctly in ALM after update?

  • Questions
  • Excel Add-ins not working correctly in ALM after update?
Question ID: 105468

I ma having issues where I had the Excel add-ins installed (correct version) and the VBA macros accepted under the Security settings of Excel. For some reason, all of the sudden they stopped working. We updated the patch version, but that is all that happened, and now my reports are not working correclty. What could be the issue?

Thanks in advance

Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on July 8, 2014 10:52 am
Answers (1)
Private answer

Hello HomerJ,
What might have happened is that the client became unregistered. Lots of the reports that use VBA processing are also using the OTA and other DLLs that need to be registered on the client in order to run correctly, I would try to run the client registration from within the Add-ins or Tools menu ( depends on the version which it is displayed as ) and see if that fixes your issue. If not, then you will need to uninstall the client, reinstall the client, and then re-run the registration to see if that resolves your issue.

Hope this helps,

Marked as spam
Posted by (Questions: 0, Answers: 771)
Answered on July 8, 2014 10:56 am
Thanks for the tip. I re-ran the registration and it all started working again correctly. Thanks for the assistance.
( at July 8, 2014 10:57 am)