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.

Members of the Microsoft 365 Insiders program can check out a new feature in the Mac version of Excel that allows users to refresh data from its From Folder connector via Power Query.

Microsoft Excel introduces PivotTable Auto Refresh, automatically updating data for real-time analysis in Windows and Mac versions.