title: VBA Update links from Master File to Multiple Files
body: <p>I have a master file that stores a lot of information. I have around 50 to 60 files that have vlookup formulas that are referencing the master file. These are also being printed out using a Print vba. When I print off the documents with the print vba the formulas are not updating based on the information in the master file.</p>
  <p>Below is the code I have in the Master file.</p>
  <pre><code>Sub Calc()
      Dim ws As Worksheet
      Application.Calculation = xlManual
      For Each ws In ActiveWorkbook.Sheets
          ws.Calculate
      Next ws
      Application.Calculation = xlAutomatic
  End Sub
  </code></pre>