Report Builder Auto Refresh | Community
Skip to main content
S
Sameer_Khaladka
Level 3
October 16, 2015
Solved

Report Builder Auto Refresh

  • October 16, 2015
  • 2 replies
  • 2603 views

Hello All,

Does latest Report builder has a capability to Auto Refresh at regular interval? Omniture ExcelClient used to have this feature but now Excel Client is no longer supported.

 

Please advise

Regards 

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 BrianAu1

Hi Sameer,

Report Builder does support auto-refresh via Excel macros. Full instructions are linked in the blog post below:

http://blogs.adobe.com/digitalmarketing/analytics/report-builder-power-user-series-create-auto-refreshing-workbooks/

Report Builder and Macros

Earlier this year, report builder introduced support for performing simple commands such as refresh via Excel VBA macros. Now if you use macros to perform bulk tasks or basic automation, you can include report builder functions in that workflow with some simple commands. For security reasons, you cannot schedule macro-enabled workbooks for regular delivery from Adobe Analytics, but you can still save and use them locally. For the purposes of our objectives, we will leverage the “RefreshRequestsInCellsRange” along with the “Application.OnTime” function calls in VBA.

Best,

Brian

2 replies

B
Adobe Employee
BrianAu1Adobe EmployeeAccepted solution
Adobe Employee
October 16, 2015

Hi Sameer,

Report Builder does support auto-refresh via Excel macros. Full instructions are linked in the blog post below:

http://blogs.adobe.com/digitalmarketing/analytics/report-builder-power-user-series-create-auto-refreshing-workbooks/

Report Builder and Macros

Earlier this year, report builder introduced support for performing simple commands such as refresh via Excel VBA macros. Now if you use macros to perform bulk tasks or basic automation, you can include report builder functions in that workflow with some simple commands. For security reasons, you cannot schedule macro-enabled workbooks for regular delivery from Adobe Analytics, but you can still save and use them locally. For the purposes of our objectives, we will leverage the “RefreshRequestsInCellsRange” along with the “Application.OnTime” function calls in VBA.

Best,

Brian

S
Sameer_KhaladkaAuthor
Level 3
October 16, 2015

Thanks

I will give it try. Regards

Terms & ConditionsAccessibility statement

Loading footer...