title: Pandas ExcelWriter breaks the excel external connection from web
body: <p>My intention is to append a data frame into an existing excel file.
  This excel file has a sheet called &quot;Price&quot;, this sheet has an external connection from the Web.</p>
  <p>When I run the code (below) and append the data frame, the connection disappears.</p>
  <p>Any recommendation?</p>
  <pre><code>#Export to excel
  options = {}
  options['strings_to_formulas'] = False
  options['strings_to_urls'] = False
  path = 'Produtos.xlsx'
  book = load_workbook(path)
  writer = pd.ExcelWriter('Produtos.xlsx', engine='openpyxl',options=options)
  writer.book = book
  writer.sheets = {ws.title: ws for ws in book.worksheets}
  BDR_df.to_excel(writer, sheet_name='BDR', index = False)
  writer.close()
  writer.handles = None
  </code></pre>