I am using Report Builder 5.0 in Excel 2013 on a Windows machine. I created a drop down control which contains my segments. I've linked the drop down to the data set as the segment source, but when I select a segment from the drop down...I get a macro error.My macro settings are wide open in Excel, so could Report Builder cause this error? Steps to duplicate:Create a new data request showing top 10 pages by pageviews for yesterday. Click next, ok.Create a new data request Click the segment control settings, select all, automatically refresh linked requests upon item selection, choose the cell, click okDrop down appears, click cancelEdit the data showing the 10 pages by pageviews. Choose the cell containing the segment drop down as the source.Click next, ok.The error states:"Cannot run the macro 'FormControlClickEvent'. The macro may not be available in this workbook or all macros may be disabled" [img]error.PNG[/img][img]macro_settings.PNG[/img]

Level 2

Solved

Report Builder - Segment Control - Macro Error

14 replies
5836 views
Translate

I am using Report Builder 5.0 in Excel 2013 on a Windows machine.

I created a drop down control which contains my segments. I've linked the drop down to the data set as the segment source, but when I select a segment from the drop down...I get a macro error.

My macro settings are wide open in Excel, so could Report Builder cause this error?

Steps to duplicate:

Create a new data request showing top 10 pages by pageviews for yesterday. Click next, ok.
Create a new data request
Click the segment control settings, select all, automatically refresh linked requests upon item selection, choose the cell, click ok
Drop down appears, click cancel
Edit the data showing the 10 pages by pageviews. Choose the cell containing the segment drop down as the source.
Click next, ok.

The error states:

"Cannot run the macro 'FormControlClickEvent'. The macro may not be available in this workbook or all macros may be disabled"

[img]error.PNG[/img]

[img]macro_settings.PNG[/img]

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

E

eham1906Accepted solution

Level 3

I fixed it...

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"
http://www.erichamilton.info/2016/05/as-heavy-user-of-adobe-analytics-i-ran.html

E

eham1906

Level 3

Glad it worked!

Translate

E

eham1906

Level 3

Adobe Client Care was not able to resolve my issue. They were only able to point me in the right direction. Here is my incident ID: 160505-000150

Translate

gary_pghAuthor

Level 2

This worked, thank you!!!!

Translate

E

eham1906

Level 3

I fixed it...

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"
http://www.erichamilton.info/2016/05/as-heavy-user-of-adobe-analytics-i-ran.html

Translate

E

eham1906

Level 3

I fixed it...

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"
http://www.erichamilton.info/2016/05/as-heavy-user-of-adobe-analytics-i-ran.html

Translate

E

eham1906Accepted solution

Level 3

I fixed it...

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"
http://www.erichamilton.info/2016/05/as-heavy-user-of-adobe-analytics-i-ran.html

Translate