I have an Excel spread sheet with a data connection to a SQL table. This Excel file is used by a label software to print labels. In the Data Connection properties I checked allowing background refresh, refresh every 60 minutes and refresh while opening the file, etc (as shown in the attached.) I assume with the data connection this file will automatically get refreshed every 60 mins with the SQL table. Unfortunately no, the refresh doesn't happen. Every time I have to open this Excel file and it will start refreshing and then I have to save it. Then my label software can see the updated records.
Isn't it supposed to automatically refresh/update every 60 minutes? Did I miss something?