Field List in Pivot tables

[SiddersAtCHEP]

Can anyone help with this?

I have a macro which populates a pivot table. When it does this, despite my having set

ActiveWorkbook.ShowPivotTableFieldList = False

before

ActiveSheet.PivotTables("PivotTable1").SourceData = "MyFile!R" & MyTopLine & "C1:R" & MyBottomLine & "C52"

It still flashes up with the Field List. I can close it down again immediately but I am trying to get it so that the users never have to see it as it will only confuse them...seriously.

Is there any way of stopping it from showing entirely?

Many thanks

Sidders