In the Excel file, select Enable Automatic Refresh when opening the Excel document.


OR
 

  1. In the Excel file, right-click the drop-down buttons for one of the headers.
  2. Mark the Show All checkbox.
  3. Click OK.