Hi

I am using the following code to set the PivotField in an existing Pivot
table:

Workbooks(filename).Sheets(sheetname).PivotTables( tablename)PivotFields(fieldname).CurrentPage = "(All)"

However the "(All)" only works in english versions of Excel. Is there a way
to set this field in a language independent way?