Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

ReportBuilder - Cell range via Excel named area

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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