To do Alt + A R A on Mac in Excel, download and install Accelerator Keys, then press Option, followed by A, R, A.
Command: Refresh All
This is how to do Alt + A R A on Mac in Excel with Accelerator Keys, the native ribbon and alt key shortcut solution for Mac users who get more done with Excel.
Alt + A R A refreshes all data connections in the workbook. This updates all Power Query queries, PivotTables, external data connections, and other linked data sources to pull the latest information from their sources.