title: "This workbook contains external data. Do you want Microsoft Excel to clear the data before saving" prompt
body: <p>I have created a macro-enabled template, which contains only a empty dataset sheet sourced to a number of pivot tables.</p>
  <p>Every time I try to save the template proper, or even a new workbook based on the template, I get the error:</p>
  <pre><code>This workbook contains external data. Do you want Microsoft Excel to clear the data before saving the template, and then automatically refresh the data whenever the template is opened?
  </code></pre>
  <p>There are no connections in data&gt;connections&gt;connections.
  Edit Links is grayed-out in data&gt;connections.</p>
  <p>I have downloaded and ran &quot;https://www.manville.org.uk/software/findlink.htm&quot; with no links found.</p>
  <p>The only item in formulas&gt;name manager the dataset table with no external link.</p>
  <p>I have unchecked file&gt;options&gt;advanced&gt;ask to update automatic links.
  I have enabled all items in file&gt;options&gt;trust center&gt;external content.</p>
  <p>I can't find anything in my VBA code that would cause an error like this.</p>
  <p>This error prompt haunts me. Why is it doing this?</p>
  <p>Thanks for any answers.</p>