I have about 6 external data connections (web data) in different worksheets, and I want to refresh all constantly, it takes about 20 seconds for all my data to be fetched, I want excel to automatically start the next refresh cycle immediately afterwards - every 20 seconds, or then ever the first cycle finishes.
I knew I can set it to refresh all every 1 minute but this is too long.
thanks
also posted in
http://www.mrexcel.com/forum/excel-q...ml#post4272945
Hi John19,
Have a look here.
Regards,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
I've tried it but can't figure out how to make it work
Last edited by John19; 09-11-2015 at 08:31 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks