Excel file's size would increase by 40–60 megabytes per day, What is the ideal solution for it?

[ManjunathReddy (P Manjunatha)]

Job stopped with an unexpected exit code: 0xE0434352

Excel opens 81 times in order to store the data in one execution. As a result, the Excel file’s size would increase by 40–60 megabytes per day. Thus, reading and writing to the colours file will be exceedingly challenging. What is the ideal solution for it?

as of now I am getting below error.

Thanks

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @ManjunathReddy .
Have you check

Job stopped with an unexpected exit code: 0xE0434352

Users with excel workflows accessing large amounts of data will encounter this error "Job stopped with an unexpected exit code: 0xE0434352", from time to time. Follow the below steps: Stop excel workflow temporarily and run a different workflow to see if the error still occurs. Make simple excel workflow that just accesses the data in the same way to see if error still occurs. Use kill excel Com object before reading excel object. Use retry scope or increase the timeout to 60-90 seconds to ens…

[devasyasingh]

@ManjunathReddy

1. Copy the required sheet from Large one into a new file.
2. Do your work in new small file.
3. Replace the old sheet in large file with new file sheet.
4. Back up the large file regularly, remove not required sheets and keep size not more than 80MB.

or

Use database or Sharepoint List