title: How to use vba code for refreshing data in an external workbook?
body: <p>I want to create a macro in my 'main' workbook to refresh the pivot table data in external workbooks (country A workbook, Country B, Country C etc.)</p>
  
  <p>I used this simple code:</p>
  
  <p><code>Workbooks.Refresh "LOCATION of file"</code> however the method refresh is not recognized.</p>
  
  <p>ex: <code>Workbooks.Open "LOCATION of file"</code> <code>-&gt;</code> opens the file...</p>
  
  <p>Is there a simple VBA Code (1 line) to update external workbooks with file path location?</p>