I am currently trying to copy a template sheet from one excel file to another. The copy part works but regardless of what I do the save dialog is shown which pauses the automation.
I’m sure I can write a way to pick up that dialog and click save, but based on what I understand I would assume it shouldn’t be prompting this.
As far as I’m aware there’s no simple setting to turn this off.
You can either write a workflow to handle it or suppress the alert through a macro. You can do this in excel and start the macro with a UiPath activity.
Application.DisplayAlerts = False
ThisWorkbook.Close SaveChanges = True