Collecting data from disparate excel workbooks into a single workbook

Collecting data from disparate excel workbooks into a single workbook

I have a main workbook with some code in it. That code opens hundreds (and
eventually potentially thousands) of excel workbooks. It extracts data
from each of those external workbooks and saves that information to
various spreadsheets in the main workbook.
The program works - and has worked. However - and I'm not sure whether
this is due to a code change or to more data - the program produces, after
working for more than 100 files, a modal dialog box for each successive
file that reads "This workbook contains links to other data sources" and
insists that I click "Update", "Don't update" or "Help." I now have to
click "don't update" 100s of times through this helpful message.
I have tried Application.DisplayAlerts=false It doesn't help. Still get
the helpful message in a model dialog box after processing a few hundred
files.
Unable to locate the Application.OverrideEveryStupidDefaultMSEverThoughtOf
property.
Is there a way to solve or circumvent this problem?