MS Query hangs in Excel
As Ken says, it's likely to be a connection error which unfortunately
can be cuaed by many things form incorrect Data Source settings on the
machine to a loose cable!
If you let it 'hang' long enough, it should eventually time out and
give an error message which might lend some clue as to where it fails.
|