Thursday, May 5, 2016

Report Builder Interactive Controls Issue

As a heavy user of Adobe Analytics, I ran into a problem using Interactive Controls recently. I could not find a solution on any Adobe website, on any blog or social site.  Adobe Support pointed me in the right direction but they did not provide a solution.  I was able fix the problem.  See below.  I hope this helps.

Problem:
Getting the following error message when attempting to use Interactive Controls in Report Builder in Adobe Analytics
"Cannot run the macro 'FormControlClickEvent'. The macro may not be available in this workbook or all macros may be disabled."

Reason:
Adobe ReportBuilder.Bridge is not enabled as an Excel Add-in (it may be enabled as a COM Add-in only)

Solution:
Open Excel
Click File
Click Options
Under Manage, select "Excel Add-ins"
Click Go
Adobe.ReportBuilder.Bridge will be missing from list.
Click "Automation"
Select "Adobe.ReportBuilder.Bridge"
Click "OK"