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-refre...
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
