Have you been getting a “Use one of these records?;” error when trying to create a new Account, Contact, or Lead? This is the result of the Salesforce native duplicate checking rules.

Starting from version 3.2.9.0, XL-Connector has an option to bypass these rules:

The method parameters for Insert, Update, and Upsert VBA calls have also changed to include a new parameter. If you are using any of these methods, please review your VBA code and make sure you’re passing the new parameter:

Update records

string[,] UpdateData(object[,] data, string objName, bool useAssgnRule, string assignmentRuleId, bool ignoreNativeDuplicateChecks, out string errorText)

Insert records

string[,] InsertData(object[,] data, string objName, bool useAssgnRule, string assignmentRuleId, bool ignoreNativeDuplicateChecks, out string errorText)

Upsert records

string[,] UpsertData(object[,] data, string objName, string extIdColumn, bool useAssgnRule,</b> <b>string assignmentRuleId, bool ignoreNativeDuplicateChecks, out string errorText)