Excel 2007 VBA...suppress "opening" message when refreshing pivot data

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...

Have you tried :

Please Login or Register  to view this content.

tried all the usual stuff on both my "control" workbook, and the workbooks it is opening via code...

Application.DisplayAlerts = False
Application.ScreenUpdating = False
Application.EnableEvents = False

thing is, it suppresses choice popups like "do you want to save"...stuff like that, but this is just a progress bar that displays the data file opening...and it still shows up no matter what..

Please Login or Register  to view this content.

Bingo!...that did the trick!...funny thing though...like i said in the original post, I have a "control" workbook, that opens other workbooks and refreshes them through code...it's the "other" workbooks that are actually being refreshed with the data, but to suppress the status bar for opening the data file, I had to put the .DisplayStatusBar = False in the "control" workbook...I would have thought it had to go in the refreshed workbook...

Oops...ok...it doesn't work...I've piled everything I can thing of on this and it still shows the progress bar...here's the relevant code with the statements to turn everything off in both the control workbook AND the refreshed workbooks...

Please Login or Register  to view this content.

And it STILL shows the darn progress bar to open files on the .Refresh statement!!!! Next idea?

Try this and modify if required.

Please Login or Register  to view this content.

that just uses the with statement so you don't have to write "myBook" or "ActiveWorkbook" so many times...that isn't really going to affect the operation of the code, is it?

If you look at it the refresh all goes before the setting of the Displays back to true

Okay...re-posting my code...and bear in mind, I've thrown everything but the kitchen sink at this, and it STILL shows the "Opening..." progress bar, when I open the workbook, when the refresh opens the data files, and when the workbook saves...what am I missing?

Please Login or Register  to view this content.

Any more help on this? Anyone? As you can see in my code above, I have thrown everything I can think of at this, and it's STILL popping the progress bars...It's driving me crazy because I know it should work...it just doesn't...