In the Excel file, select Enable Automatic Refresh when opening the Excel document.
OR
- In the Excel file, right-click the drop-down buttons for one of the headers.
- Mark the Show All checkbox.
- Click OK.
In the Excel file, select Enable Automatic Refresh when opening the Excel document.
OR