I want to have automatic background refresh when the workbook is closed. I've set a testing time to update (see the screenshot below), but it never works.
FYI, I'm trying to refresh data from the external Oracle Database. When I refresh data myself clicking on Refresh button, it works perfect. But it doesn't refresh automatically in the background when file is closed, what could be the reason and is there any workaround to solve that?