Which file contains the value of 2 billion? I tested this out with the current Quik Link, Office 2000, and a posted batch in GL of this amount, and it worked OK. My link in this case was to the GLPST (or posted transactions) file in GL. Is the value exactly 2 billion or a little bit larger?

I wouldn't think that Quik Link would encounter any problems with large numbers, any more than Excel or GL would.

From the Excel Help file, #value usually indicates something is wrong with an Excel formula, rather than not being able to interpret a large number. If you search Excel help for #value, there is a specific topic about it with some suggestions.

Regards,
Softrak Support

I'm afraid I haven't been able to duplicate this one yet. I have posted amounts of 3 billion (dollars with 2 decimal place currency) to my accounts, and Quik Link has read them properly. I used the range function to sum accounts with multiple billions each, and that was OK as well.

Note that in the formula text you posted, you have a semi-colon ';' between the link name and the account. As with all Excel formulas, this has to be a comma ','.

Try the formula syntax:
=accpac("gldata.Y","502010")

where gldata is the link name, Y is the field, and 502010 is the account, and no department. Alternately, try with department 4500:
=accpac("gldata.Y","502010-4500")

I'm pretty sure the issue has to do with formula syntax. The values are being read for me correctly under Office 98 and Office 2000.

Should you still have problems, try creating a new workbook with the same link name, etc, and see if the problem exists again.

Regards,
Warren Flett
Softrak Support

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