Report Builder - Segment Control - Macro Error

Avatar

Avatar

gary_pgh

Avatar

gary_pgh

gary_pgh

15-10-2015

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:

  1. Create a new data request showing top 10 pages by pageviews for yesterday. Click next, ok.
  2. Create a new data request 
  3. Click the segment control settings, select all, automatically refresh linked requests upon item selection, choose the cell, click ok
  4. Drop down appears, click cancel
  5. Edit the data showing the 10 pages by pageviews. Choose the cell containing the segment drop down as the source.
  6. 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]

View Entire Topic

Avatar

Avatar

alibaba1

Avatar

alibaba1

alibaba1

15-10-2015

I'm also experiencing this issue. @Gary - did you find a work around?