title: xlsx error: "Removed Records: Named range from /xl/workbook.xml part" when tried to resolve errors
body: <p>I have an xlsx file that I generate using SSIS. The data to this file is written through a data flow task where the xlsx file is the oledb destination. I have used the following connection string as an expression for the OLEDB connection:</p>
  
  <pre><code>"Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+ @[User::ExcelPath] +";
  Extended Properties=\"Excel 12.0 Xml;HDR=YES\";"
  </code></pre>
  
  <p>The file opens just fine before the data flow task. After the data flow task, I get a dialog as follows:</p>
  
  <p><img src="https://i.stack.imgur.com/i3QGS.png" alt="enter image description here"></p>
  
  <p>When I click yes, I get another message:
  <img src="https://i.stack.imgur.com/ExyqC.png" alt="enter image description here"></p>
  
  <p>The contents of the xml file are</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"&gt;       &lt;logFileName&gt;error072840_02.xml&lt;/logFileName&gt;&lt;summary&gt;Errors were detected in file   'C:\output\documentId-1.xlsx'&lt;/summary&gt;&lt;removedRecords summary="Following is a list of removed records:"&gt;&lt;removedRecord&gt;Removed Records: Named range from /xl/workbook.xml part (Workbook)&lt;/removedRecord&gt;&lt;/removedRecords&gt;&lt;/recoveryLog&gt;
  </code></pre>
  
  <p>I am not able to figure out what exactly is causing this error. Any help will be appreciated. TIA</p>