Linked table - Numeric Field Overflow error

[klgfinance]

I would appreciate some help w/ an error message I keep getting. I have a linked table in Excel, & when I refresh the link via linked table manager, my report (source: macro based on query based on that table) runs fine....but only one time. Afterwards I get the "numeric field overflow" error. If I refresh again, it works again for one more time, then back to the error message.

What could be causing this? and/or how can i fix it?

Is there some code I can put into the macro somehow so it would automatically refresh the link prior to executing the rest of the macro for the report?

Thanks!

 

[SydneyGeek]

Overflows usually indicate that the wrong number type has been used.
For example, if you have a Number field set to Integer, the upper limit is 32K. Exceed that (easy to do by looping down a spreadsheet, for example) and you get an overflow. Set the number to Long Integer (which handles values up to around 2 billion) and you should be OK.

Denis