Run Time Error 3163: The Field is Two Small to Accept the Amount of Data that You Attempted to Add. Try Inserting or Pasting Less Data.


Symptoms


"Run time error '3163': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." This error occurs when adding information into a Link to External Worksheet Column in FRx 6.5.After clicking OK, FRx will exit and need to be restarted.

Cause


More than 100 characters were entered in the Link to Worksheet column of the Row Format.There is a 100 character limit when defining the cell references from an external worksheet.

Resolution


To prevent this error, enter less than 100 characters in the Link to Worksheet column. If you must use more than 100 characters, create an additional Link to Worksheet column in the Row Format and add the additional values beyond the 100 characters.

References