Excel Services in SharePoint 2013 Prompt for Data Refresh

While working to get the various dashboards to work for the TFS 2013 Agile template I noticed the all the charts kept asking me Do you want to enable these queries.  After clicking on yes a few times this got old.  Did some digging and there is an easy way to allow them to connect to there data sources and refresh when the page loads.

Here is the message I was talking about:

To remove the warnings you will need to do the following.

1. Browse to your SharePoint Central Administration page
2. Under Application Management click on Manage service applications
3. Click on Excel Services Application
4. Click on Trusted File Locations
5. For both your short name address (http://shortname/sites) and FQDN (http://sitename.mysite.com/sites) change the Warm on Refresh setting to No/False and click on OK to save it

Happy Face!  No more click on Yes