The "Connection Properties" dialog box opens. Make sure you are on the "Usage" tab of the "Connection Properties" dialog box. Select the "Refresh Data When Opening the File" check box and click "OK." ...

The Refresh Recommend is usually a sign that the data in the workbook might be outdated. Excel suggests refreshing the data so that the most up-to-date version can be retrieved.