I have an app where I've exported a local excel table to a Data Table, however, getting the app to refresh automatically has been difficult.
I've tried having the OnTimerEnd value = Refresh(datatable) with no luck, and tried changing it to Refresh(datasource) with the same result. The only option I have to get new data is completely remove the connection and re-import. This can't be right.
How can I have a Data Table using imported local sheets update automatically with a timer?