Skip to Content
Former Member
Apr 28, 2010 at 07:11 AM

Automatic refreh for a workbook


Hi experts,

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 !