title: Remove a data connection from an Excel 2010 spreadsheet in compatibility mode
body: <p>Situation: an Excel 2010 workbook is created using data from oracle.  A data connection is created to achieve this.  The excel workbook is then saved as a .xls file so that customers with older versions of office can access it.</p>
  
  <p>Problem: a warning message is displayed when the workbook is opened: </p>
  
  <p>'Security warning       Data Connections have been disabled           [ Enable content]'.  </p>
  
  <p>We think this is shown because the data connection is still present in the workbook.  You can go to Data->Connections and remove it, but when the workbook is saved and re-opened, the data connection has come back (although with empty definitions fields).</p>
  
  <p>Things tried: removing all data connections using a macro: no joy.  The 'Name Manager' method described here (http://www.mrexcel.com/forum/showthread.php?t=467938) : no joy.</p>
  
  <p>Has anyone else seen this behaviour?</p>