Exporting Query To Pivot Table Remove Subtotals

[mr.donaldson]

I have a form built with multiple buttons. Once the user clicks the button and enters their parameter, I am using VBA to export the data to an excel pivot table. I would like to turn the subtotals to false so as the user clicks the check boxes in the pivot there are not any totals, subtotals, or grand totals. I am not sure how to add that to an existing query? Any help would be appreciated. Thanks

 

[MarkK]

double post.