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 DataImport Ext DataEdit QUery and get it
to works again, even for February. Is this a connection error? Any
suggestions?