Hello All,
I am having issues with automating some data in an excel sheet. The file is password protected and I am able to enter the file. Right before, I get a pop up asking if I trust the links in the workbook and if I would like to update them. This stops my process from being automated. Is there anyway to bypass this? The Macro setting is set to automatically update links, but for some reason I still get the pop up.