I was able to get my pivot table running using the following code:

Please Login or Register  to view this content.
Normally, after the pivot table is created and the fields are set, the table displays all the data in the two columns.

The problem is that when the pivot table generates, it comes up filtered as "Select All", with every box checked, but shows nothing. To make the data appear, all I need to do is click the filter and click OK (all the boxes remain checked from before) to show the data. I want it to just auto-show everything without me having to manually do it. I recorded a macro for it but it comes up blank, which is weird considering it normally shows filter categories.

I browsed around and found code to essentially just "Select All." However, it takes about a minute to run each time, which is a waste of time and inefficient since I need to run it hundreds of times.

Please Login or Register  to view this content.
Any help would be appreciated.