I have created a chart in excel using PowerPivot and I am using oData Data Feed to get values from my SharePoint List. I have set auto refresh at every 60 minutes and I have used some filters also.
I have displayed my chart using Excel Web Access web part and following properties are set to the web part.
- All PivotTable & PivotChart Interactivity
Now what happens is my chart is not updated at particular period and if I am trying to filter for the first time after page load it is asking for confirmation to refresh the workbook as below.
Is is possible to avoid this confirmation? If yes then how?