we have a shared spreadsheet ,numerous users access, and there are many
copies, and all r affected: it pulls data from a SQLbase db based on a range
of dates. when we open the file we often see this Excel error:
[INTERSOLV][ODBC SQLBase driver][SQLBase]02212 EVA NOF Numeric overflow
but you click ok, it refreshes the data, and you see the results.
we found that if you put in dates for February (eg 2/1/2005 through
2/28/2005) the data stops refreshing and the data disappears. by trial and
error i found if you go back to January, and going to the sheet where the
query is run from, you can go to Data>Import Ext Data>Edit QUery and get it
to works again, even for February. Is this a connection error? Any
suggestions?
Bill Manville - 24 Feb 2005 08:19 GMT
I don't know anything about the Intersolv driver.
Google showed me other messages on a similar subject (without replies)
in other groups, relating to the Intersolv driver.
You could try contacting Intersolv:
http://www.intersolv.com
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup