Hello,
1. Can you use any other functions of the Kutools for Excel?
2. Please try to create some sample data in a new workbook and try to apply this function again.
3. If the problem persists with the sample workbook, please attach it here or send it to jaychivo@extendoffice.com with detailed information.
Thanks in advance.