VBA Created Pivot Table Doesn't Show Data

I've written some VBA to create a pivot table. It works fine. The only problem is that when it's first created, it only shows the headings. As soon as I click on one of them, then all of the values show-up.

I've tried refreshing the Pivot Table in the code, but that doesn't work.

Please Login or Register  to view this content.