ReportBuilder - Cell range via Excel named area | Community
Skip to main content
H
hmueller1
Level 2
October 16, 2015
Solved

ReportBuilder - Cell range via Excel named area

  • October 16, 2015
  • 1 reply
  • 1048 views

Hello,

in ReportBuilder, we want to pull data for all our Site Channels (eVar), so I created a named cell range "Sitechannels" with the Excel name manager and specified the lookup in ARB as "Specific / from range of cells" with the range "=Sitechannels".

I now updated the list of Site Channels and realized that the ARB did not update, as ARB "converted" my name range back to an absolut cell range, e.g. A1:45. So I have to update all requests (>30) with this lookup manually.

The expection is to make use of the Excel name function, so all updates of a lookup range will also be reflected in the ARB requests.

Is this "as designed" or another ARB bug?

 

BR

Hans

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

Hi Hans,

 

I believe it is working as designed. You have to refresh manually. OR you can use the function listed in this doc : 

http://microsite.omniture.com/t2/help/en_US/arb/invoke_arb_excel_function.html

I think if you use the functions you will be to obtain what you need have fun.

 

Best regards.

 

Alexis Cazes

1 reply

Alexis_Cazes_
Alexis_Cazes_Accepted solution
Level 10
October 16, 2015

Hi Hans,

 

I believe it is working as designed. You have to refresh manually. OR you can use the function listed in this doc : 

http://microsite.omniture.com/t2/help/en_US/arb/invoke_arb_excel_function.html

I think if you use the functions you will be to obtain what you need have fun.

 

Best regards.

 

Alexis Cazes

Terms & ConditionsAccessibility statement

Loading footer...