I created a ticket and was able to find the following: Autofilter and sort options do not work with the Pivot table options. They will not allow the proper exporting of data to Excel. Frozen headers will not work with setting a specifc pageheight option. The pageheight will not allow the header to stay frozen. Hope this helps if others run into any of the same issues!
... View more