I am working on a heavy excel sheet for automation, writing data in many cells, and i need the excel application to save the sheet only at the end. However, the automation is saving the sheet after every write cell and thus making the process extremely slow.
Is there a workaround or a way to ensure that the save is skipped?
Also, someone told me about AutoSave property in WriteCell activity, but I cannot see that one in my Studio, although my colleague can see the same for the same workflow. So this option to avoid saving is not working for me.
Any inputs on both the issues would be very helpful.