Hi.

I have created some VB script using a macro. The data includes a date column and the pivot seems to group the dates and adds an extra column called months which I don't want. Sample of the bit of code in question below:-

ActiveSheet.PivotTables("PivotTable1").PivotFields("Months").PivotItems("May"). _
ShowDetail = True
Range("F13").Select
ActiveSheet.PivotTables("PivotTable1").PivotFields("Months").PivotItems("Jun"). _
ShowDetail = True
ActiveSheet.PivotTables("PivotTable1").PivotFields("Months").Orientation = _
xlHidden

Is there any way I can put code in to stop it doing this in the first place?

Thanks.