Hello
I have made a pivot table with the code below but when i add a new date "rows" the new data didn't appear in the pivot table
how to Fix it ??
Range("A5:S1000").Select
ActiveWorkbook.Worksheets("PIVOT1").PivotTables("PivotTable2").PivotCache. _
CreatePivotTable...