Have you ever encountered such problem: use RPA.Excel.Application to handle excel file (.xlsb), it gets struck while I use close_document method.
I have done many things before I close the workbook, such as copy data from other excel to the different sheets of this excel, refresh PVT, calc the formula and so on.
After that, I want to save and close this excel file (the size is about 300MB++), it always strucks even few hours, I have to stop the RPA robot manually, when I re-open the excel file manually it shows that it had to be repaired.
I really have no idea how to do that now, who can help me?
Thank you very much.