You're correct that the 'scale' feature on the link has something to do with it. I created a link with a scale of 1000, and though a posted amount of 2 billion came through OK, the amount of 3 billion had a problem. I am using Office 2000.

If this is a problem, based on how you want to format your spreadsheet, you probably have to use some Excel formulas to work around it.
First, the link would no use scaling. Next, since you're scaling by 1000, you'd have to divide the cell contents by 1000, then format the column so the numerical amounts so not show decimals. You may also have to use a ROUND or TRUNC formula if you want to round amounts to the nearest amount, or truncate the amount.

I have a gut feeling that the problem number where this error starts to occur is 2 to the power of 31, or 2,147,483,650. Numbers with an absolute value greater than this would require more than 32 bits to store it. Of course I'm speculating, but perhaps that the scale feature requires conditions to manipulate the amounts, and it can't handle numbers greater than the one above.

I'll have to check into this with development, but this may be Excel related and we might not be able to do much about this.

Thanks for your work on this.
Softrak Support