To refresh a locally saved Connected Excel file, open the file and go to the Data > Queries and Connections then click Refresh All to refresh. 

You will be prompted to authenticate. If your email isn't automatically filled in, use the same email address as you use to log into the portal. Once authenticated the report will refresh to the most recent refresh date.