ReportBuilder - Cell range via Excel named area | Adobe Higher Education
Skip to main content
H
hmueller1
Level 2
October 16, 2015
解決済み

ReportBuilder - Cell range via Excel named area

  • October 16, 2015
  • 1 の返信
  • 1048 ビュー

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

このトピックへの返信は締め切られました。
ベストアンサー 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 の返信

Alexis_Cazes_
Alexis_Cazes_回答
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

契約条件Accessibility statement

Loading footer...