I’m facing a perplexing issue with an automation process involving Excel files. I have a robot that reads and modifies a specific Excel file, and while it sometimes completes the task successfully, at other times, it fails with an unexpected exit code: 0xE0434352.
I’ve tried to identify a pattern, but the error occurs unpredictably and only with this specific Excel file. I’m not sure if this could be related to the Excel file’s structure, data, or some external factors like system memory or file permissions.
Has anyone encountered this error code before, or does anyone have insights into why this might be happening? Any tips on troubleshooting steps or possible causes would be greatly appreciated!
Hi Anil, the excel file is 22mb, has not external links, in the workbook the excel scopes are being used 4 times and is not located in the one drive. I dont know about the macros, but i am sure that the file dont work with it.
I am having the same issues as described in the issue summary.
The process we have is using a large Excel Workbook with ~20 Sheets full of data within Sharepoint.
It is effectively grabbing the file, grabbing a sheet of the file, recalculating some values and write range over the existing data with updated data.
The process works perfectly fine for all except one of the sheets. The sheets have the same number of rows/cells and the first attempt to fix was to reduce the size of each sheet by approximately half (~2800 rows to 1500 rows).
I have tried to write to a new/clean file and it still fails suggesting something is wrong with the data/datatable attempting to be written.
Any ideas what it could be or what to look for in this large worksheet to fix?