Max Attachment Size Limits in Salesforce
Salesforce has a File Size Limit which limits the size of the attachments to be uploaded for a single record on Salesforce. For more information regarding attachment limits refer, File Size Attachment Limits in Salesforce .
If you increase the file size limits in Salesforce, you can set the file size limit per attachment in a record in X-Author for Excel. Navigate to App Settings and set the Max File Size limit. This limit indicates the maximum size of an attachment that can be uploaded to Salesforce.
Suppose the records in your application comprise the attachment field and have multiple attachments. During insert or upsert, the insert or upsert transaction request is chunked into multiple Salesforce transactions so that all the attachments are inserted or upserted successfully.