In Excel 2007, I have a workbook that loops through and opens a series of other workbooks containing pivot tables and data and does a "refresh all" on those workbooks. My problem is that I want this to be an automated process that I can start and minimize and work on other things...BUT...on a few of my pivot workbooks with especially large data files, when the code hits the line to refresh the data, I get a popup window that shows the opening progress of the data file. How the heck do I suppress this popup? I have tried .DisplayAlerts=False, .ScreenUpdating=False, I even threw in a .EnableEvents=False...still get the popups...