- Print
- DarkLight
- PDF
String Parameter too Long
- Print
- DarkLight
- PDF
Issue: 5854: String Parameter too long. Error returned when first merging in Word document
![image-Z179DG80.png](http://cdn.document360.io/df431543-7786-4800-b194-9fdd8742cc10/Images/Documentation/image-Z179DG80.png)
Analysis: This error typically indicates that worksheets with range names have been copied into the current workbook. Microsoft Excel copies the path of the source workbook and duplicates all range names. This creates extremely long references that word is unable to parse.
Correction: Check the Name Manager in Excel for external references and delete.
Open the Name Manager in Excel → Formulas Ribbon → Name Manager
Click to sort by the “Refers to” column
Scroll and search for references to a drive, for instance C:\, containing an external file path
Highlight all external references and delete - Be careful as inadvertent deletion of range names cannot be undone.
Save and Prep the Excel file and attempt the Merge again
Prevention: Always utilize Merge Workbooks when copying worksheets from another workbook to prevent issues with duplicating range names. This utility was created to workaround Microsoft Excel’s mis-management of range names.