Hello,

I have an Excel (Office 2010 Professional) file that uses a Power Pivot connection.  I want this file to refresh whenever it is opened, so I've set the 'Data > Connections > PowerPivot Data' property setting to 'Refresh data when opening file' to true (checked).  The problem is I get the "Security Warning - Data connections have been disabled" warning with a command button to "Enable Content" (see image below).  This is breaking my auto-refresh and the user has to go through the PowerPivot refresh themselves.

Is there a way to allow the file to auto-refresh and not get stopped by this security warning?

Thanks,



This thread may have the answer for you.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6dbbbf0a-a941-4ac9-8e70-6ada34035199/external-data-connections-problem?forum=sqlkjpowerpivotforexcel

• Proposed as answer by Charlie LiaoMicrosoft contingent staff, Moderator 54 minutes ago