I have build a pretty complex workbook with lots of sheets and queries linked.
Results are OK, but it gets a lot of time to get refreshed (more then 6 minutes in production...), so I don't want to tick the box "Refresh workbook on Open" in the Workbook settings....
Here is my question : is it possible to refresh automatically the data (for example during the night) in order to open directly an updated workbook ?
I don't want to use broadcast options in this case... just to have refreshed data without launching variable value screen. Is it possible ?
Thank you in advance for your help !