Excel stuck Waiting for Server on Query

%3CLINGO-SUB%20id%3D%22lingo-sub-2403228%22%20slang%3D%22en-US%22%3EExcel%20stuck%20Waiting%20for%20Server%20on%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2403228%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20add%20a%20fairly%20simple%20EXEC%20query%20to%20Excel.%26nbsp%3B%20In%20SSMS%20it%20takes%208%20seconds%20to%20run%20and%20returns%20approx%2085k%20rows.%3C%2FP%3E%3CP%3EWhen%20I%20add%20the%20query%20to%20Excel%20the%20preview%20pops%20right%20up%2C%20but%20when%20I%20go%20to%20'Close%20and%20Save'%20it%20just%20sits%20there%20with%20the%20spinny%20thing%20next%20to%20%22Query1%22%20with%20%22Waiting%20for%20%3CSERVER%3E%2Fdatabase%26gt%3B%22%20message.%3C%2FSERVER%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20a%20%22SELECT%20*%20FROM%20%3CTABLE%3E%22%20that%20returned%20230%2C226%20rows%2C%20but%20it%20took%20about%2030%20sec%20to%20load%20them%20all%20into%20Excel.%26nbsp%3B%20The%20same%20query%20in%20SSMS%20took%2010%20seconds.%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20been%20about%2010min%20and%20we%20are%20still%20%22Waiting%20for...%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20similar%20EXEC%20with%201256%20results%20worked%20and%20took%20about%202sec.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHELP%20PLEASE!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FTABLE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to add a fairly simple EXEC query to Excel.  In SSMS it takes 8 seconds to run and returns approx 85k rows.

When I add the query to Excel the preview pops right up, but when I go to 'Close and Save' it just sits there with the spinny thing next to "Query1" with "Waiting for <server>/database>" message.

 

I tried a "SELECT * FROM <table>" that returned 230,226 rows, but it took about 30 sec to load them all into Excel.  The same query in SSMS took 10 seconds.

 

It's been about 10min and we are still "Waiting for..."

 

A similar EXEC with 1256 results worked and took about 2sec.

 

HELP PLEASE!

 

Thanks!

 

1 Reply

@Dizzy49 

If I let sit for a while I get the following error:

"[Excel DataSource Error] Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding"