Filter Pivot table error

[vikny11]

Hi,

I am trying to filter a pivot table field named ("id") with ID="xyz". Below is the code I am using however I am getting a application or object defined error. Please let me know how to fix this error. Thanks for your help.


Sub filter()

With Worksheets("xyz").PivotTables(1)

.PivotFields("id").PivotFilters.Add Type:=xlCaptionEquals, Value1:="B10059"

End With

End Sub

 

[RoryA]

Where is the id field located in the table?

 

[vikny11]

Its the 3rd field (3rd column) in the pivot table

 

[RoryA]

Works fine for me as long as that value exists. If it doesn't I get that error.

 

[vikny11]

the data for this pivot comes from a closed workbook on the Sharepoint site. Can that be a reason for the error?

 

[vikny11]

Also, the pivot table is copied from Excel 2003 workbook into an excel 2010 workbook. The data source for this workbook is in Excel 2003 and VBA code for filtering the pivot table is in Excel 2010. Please let me know if this is causing the error.

The above statement for filtering the data worked finr when both the data and pivot table were on the same worksheet (excel 2010)

 

[RoryA]

The above statement for filtering the data worked finr when both the data and pivot table were on the same worksheet (excel 2010)

I think you've answered your own question, have you not?

I don't use Sharepoint so don't know if that's an issue.