Excel report refresh Automation

[MamtaL]

Hello Team,
We have created Pivot table report in excel from HANA DB. We have to refresh this pivot table report once in week. When we refresh this report excel get fully occupied till refresh completes. 
So, I would like to know is there any possible solution in Alteryx where we can refresh my excel report with minimum time utilization.

kindly Note, Every refresh should fetch data from SAP HNA DB.

Thanks.

[Yoshiro_Fujimori]

Do you want to refresh your summary table without locking the source data?

If so, I would use BI tools such as Tableau and Power BI rather than Alteryx.