Stopping automatic popups when opening files

**MikeFranz123** · 04-19-2012, 06:27 AM

Hi everyone,

I am opening files using VBA, but when I open the file it asks me if I want to edit links. I've tried using "Application.AskToUpdateLinks = False" but that doesn't seem to work, nor does application.displayAlerts = False. Also, I've done it manually by editing links in the excel document itself, but I would like to be able to do it automatically.

Any suggestions would be appreciated! Thanks!

**johnjohns** · 04-19-2012, 06:55 AM

I tried this for a workbook with external links without any prompt for updating links

Please Login or Register  to view this content.

To update all the links perhaps

Please Login or Register  to view this content.

**MikeFranz123** · 04-19-2012, 08:27 AM

Ok great, that seems to work, only thing is it now asks me individually about the links when I run the second line of code. Is there anyway to make it do that automatically? i.e. just make it update all the links.
Thanks for your help!