Interview Question in SQL Server Triggers
Interview Question :: Excel external data timeouts
I have a number of sheets which fetch the data from SQL server - unfortunately the sheer quantity of the sheets is overwhelming the server and when the sheets refresh (on open), the server timeouts - which means that the data does not refresh.
My question is : how can I either stagger the refresh, increase the refresh timeout duration or have internal VBA code iterate over the sheets and trigger data refresh manually?
Loading ...