Disabling the "Do you want to update..." message

[ttocs]

Hey guys,

I have a script I run each morning that kicks off a report. Took me a while to do, but it's finally finished. Now, I'm just cleaning up some of the spots that work, but not efficiently. One such spot, is when I open up this one file. The excel file always asks me if I want to update the contents. The answer is always no, and after I click it, it goes about it's job. I thought that putting the DisplayAlerts = False script would do the trick, but I'm still seeing it. Anyone have the code to disable any popups when I open another workbook? All I can find on google is the displayalerts one.

Thanks!

[Bob Phillips]

Has it got links? If so, set the Updatelinks property to 0 in the Open method.