Open the Excel
Go to Data > Click on the arrow on the Refresh All option
Select connection properties
Set the Refresh interval as per our need
Click OK
Open the Excel
Go to Data > Click on the arrow on the Refresh All option
Select connection properties
Set the Refresh interval as per our need
Click OK