ExcelBanter - 1004 General ODBC Error

Not much help, I'm afraid; just an explanation: OLAP uses ODBC in the
background, I believe. Why it is erroring I can't say. A General ODBC error
is often an attempt to use a function not supported by your driver so it may
be dependent on the particulars of your DB engine. If the error tends to
happen on more complex data sets perhaps you are exceeding some limitation of
the query parameters or something.

You may want to search MDSN - this might be a good starting point:
http://msdn.microsoft.com/data/
Perhaps try a search on "OLAP ODBC" or "General ODBC Error". Also suggest
you go to the support site for your database driver and look at their info on
ODBC/OLAP.
--
- K Dales

"YCI" wrote:

Has anyone experienced this problem?

It occurs intermittently when we open an Excel report (heavy on VBA), so the
workbook would appear to be the problem.

The crazy thing is, this report uses OLAP and not ODBC at all.

99 out of 100 times, it works fine. 1 in 100 times, we receive this error.

If anyone has seen this before and can shed some light on this, I'd
apprecaite it.

Thanks.