Does anyone know of a way to refresh a web query that will eliminate the lag? I know that the time it takes to refresh cannot be changed but perhaps there is a way to avoid the visual lag on the spreadsheet. I recall someone placing the query on a separate workbook and calling a procedure that refreshes it from the main spreadsheet.. or is it possible to fill an array with the data without visually refreshing the table? Any ideas?

Thanks!