Batch Macro - Reading Excel Files - Error (Tool #8: INTERNAL ERROR)

[kreynolds]

Hello all,

I am using a batch macro to read excel files out of a directory into Alteryx. The majority of the files read successfully, but a few return "Tool #8: INTERNAL ERROR". I have copied the entire file path into file explorer and it successfully brings me to the file. There is no difference between the files that don't read and the ones that do. But the same files won't read each time. I can't share the workflow due to sensitive data, but below are some screenshots.

Any ideas on the issue?

[HomesickSurfer]

Hi @kreynolds Not rows, columns.  How many columns?

[kreynolds]

Only 24. I also deleted all columns after my data.

[JoeApples]

Has anyone found a solution to this issue? I am facing the same exact error (which i have never seen before).