Pivot Grid mode will also cause all rows to be fetched.
So will a filter.
The filter should clear when you run another query though.
If none of these suggestions solve the problem, you can email me your user files folder and I will try it with your settings. Details on where that folder is, as well as my email address are in this post.
-John