title: Managing links in Excel source workbooks when duplicating source files
body: <p>I have three files:</p>
  
  <p>Activefile - where my code is stored and run</p>
  
  <p>Databasefile - where my raw data is housed (has lots of protection)</p>
  
  <p>Copyofdatabasefile - is a copy without the protection</p>
  
  <p>I have a macro that runs in <em>activefile</em> to update a <em>databasefile</em> excel file, later in the macro, I then use the saveas method on the <em>databasefile</em> to make a <em>copyofdatabasefile</em> file, I remove some functionality to allow people to access the data easily without going through some of the checks on the main <em>databasefile</em>.</p>
  
  <p>When saving the <em>copyofdatabasefile</em>, the links in my active file are updated to look at the new <em>copyofdatabasefile</em> file. I don't want this to happen.</p>
  
  <p>How can I adjust my excel links/code to ensure that the links in my file aren't transferred across to the <em>copyofdatabasefile</em>?</p>
  
  <p>Saveas macro options are currently:</p>
  
  <pre><code>Databasefile.SaveAs filename:="\\somelocation\copyofdatabasefile.xlsx", FileFormat:=51, CreateBackup:=False
  </code></pre>