I have a macro that opens many new workbooks and pulls data from them. However, after the first workbook is opened, I am asked to update the links. After clicking "update links" I then receive another message box saying some links could not be updated and I then click "Continue". The macro runs fine after this. I would like the macro to automatically make these selections. Can anyone send me a link to some resources that may assist me?

Thanks,
Paul