Has anyone experience of using the Sort or SortSpecial methods on a PivotTable Report? <BR><BR>I have tried a couple of permutations but to no avail : &#039;Method of Sort Failed&#039;being the error message.<BR><BR>TableDestination:=xlSheet1.Range(" A9")is the area I need sorted based upon the "Grand Total" column and the pivot table data is coming from an ADO recordset. I&#039;m not sure what to pass as the :key1 property of the Sort method if the Grand Total column is going to be dynamic.<BR><BR>Any help or pointers appreciated.<BR><BR>Thx<BR><BR>P<BR><BR><BR>