Hi all, I posted this question in Mr. Excel forums, but I haven't gotten any solutions yet, so I was wondering if maybe someone here would be able to help me out. Here's the link to my original question:
http://www.mrexcel.com/forum/excel-q...ibly-excel-bug
I've also copied the original question onto here for those that don't want to follow the link:

So I'm having this super weird problem, and I can't think of an explanation for it other than it being some sort of Excel bug. The code isn't really necessary to look at, but I'll post it anyway for the curious.
Please Login or Register  to view this content.
So here's my problem: I have 3 pivot tables in my workbook that won't refresh. I don't get an error... they just silently fail to refresh. All the other pivot tables in my workbook do successfully refresh. Here's the weird part: When I run through the code step by step (F8), it works fine, and the pivot tables refresh perfectly. Another weird part: If I run the first macro, and then the second macro (RefreshCaches), the tables will fail to refresh when I run the first one, and work fine when I run the second one by itself, even though the first sub obviously references the second one.

Any ideas as to what the problem could be? I've tried writing the refresh code like 10 different ways... referencing the tables individually via a "with sheets" block doesn't work, nor does using ThisWorkbook.RefreshAll, or PivotTable.RefreshTable. The only thing that works is running the code manually, step-by-step, by itself, or in the immediate window.

Thank you in advance for any help, looking for ideas, using version 2010.