Hi,
I have a pivot table field that automatically updated according to a cell value. I use a bit of average VBA coding to update this on a couple of sheets. It works great for me on Excel 2013 however the line below errors on Excel 2010.
ActiveSheet.PivotTables("PivotTable2").PivotFields("Asset name").PivotFilters.
Add2 Type:=xlCaptionEquals, Value1:=Range("C4").Value
Any reason why this would be happening? Thanks all!
Bookmarks