SOLUTION FOUND!

http://fluxenkind.blogspot.com/2008/...launching.html

It doesn't make a lot of sense, but it 100% works. My pivot table refreshes now without using MS Query at all. Everything is much faster and I can even see the row count as it comes in, so it's not blind faith that it is working.