UpdateLinks:=1 (or3), automatically Continue!

Simple request:

On a daily basis, I've got to open several spreadsheets that need to have their links updated, but always get the annoying question:

‘this workbook contains …. Cannot be updated’
Continue Edit Links…

I'd like it to auto select Continue so I don’t have to sit around and click the button 20 times.

Things like:
Application.AskToUpdateLinks = False
blah blah blah
Application.AskToUpdateLinks = True
Do nothing.

Please respond if you have the solution

Thanks

then dont respond if youre too lazy

then dont respond if youre too lazy

anyone else care to actually answer the question

thanks

searching forums for keywords is time consuming and wasteful.

careful reading of the original post would have revealed 'Please respond if you have the solution'

you still have a chance to fix this...

does anyone have the code or the location to a proper answer

Excel Help, as expected, says NOTHING about bypassing the 'continue’ button.

I reiterate – PLEASE RESPOND IF YOU KNOW THE ANSWER

Shg – moderators are supposed to answer questions, not give half-witted smart-*** remarks. stop wasting our time!