Hi I currently generate excel workbooks from a template which has a pivot table which I've ordered by the row grand total. My Java code executes the lines below and the spreadsheet gets generated with the new data. Howev…...similar to the filter issue highlighted here: Retain filter information...although the order is kept, the filter I have in the template to ignore...