Create a new Macro to refresh the Excel data

Create a new Macro and paste the below command

Sub Update()
'
' Update Macro
'

'
Range("A6").Select
ActiveWorkbook.RefreshAll
End Sub

Click on the Insert tab and select 'button'


Click anywhere in the Spreadsheet
You will get the below prompt, click on update to use the Macro you just created and click on ok

Now you are ready to use your Macro refresh button!