Hi,

maybe you should retrieve your data using ADO instead:
http://support.microsoft.com/default...b;EN-US;246335

arno

Adding a breakpoint to VBA code and using F8 to step through the code
produces desired results. Without the breakpoint the program fails. I
traced the problem to a worksheet which is not filled in from an SQL query
earlier in the code... the worksheet displays "External Data_1: getting
data..." instead of having valid data from a query.

Hi,

.Refresh BackgroundQuery:=True

I do not know if this applies here, however, I had trouble with big data
amounts when I turned on "background" in ODBC-Databases with FoxPro. I got
very misleading errors. So, I would suggest that you test your queries with
lots of records as result. If everything is ok then fine!

regards

arno