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." ...

An Excel Web Query allows you to retrieve the latest real-time data and insert it in your spreadsheet. However, Web Query does not refresh data in the table automatically.

The REFRESH RECOMMENDED error in Excel gives us the option to discard or save changes, but if the issue persists, you can follow these solutions.