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.

How to Program an Excel Spreadsheet to Auto-Update From the Web. While you can certainly copy and paste data from a network or Web-based external source into Excel, importing the data by ...