Here is Microsoft’s solution for a problem with Excel 97 when using a Oracle data source. Now take a closer look on the second method suggested by Redmond:
If you move your mouse pointer continuously while the data is being returned to Microsoft Excel, the query may not fail. Do not stop moving the mouse until all the data has been returned to Microsoft Excel.
And I always thought improving performance by waving the mouse around was just silly superstition. Gee, I was wrong!
[Source: The CodeProject’s Lounge]