Runtime Error '1004': Method 'Pivot Tables' of object '_Worksheet' Failed

Hi I have some pivot tables on different sheets where I have disabled the field settings, when i try enable the field settings i get the following message Runtime Error '1004': Method 'Pivot Tables' of object '_Worksheet' Failed. this only occurs on 1 of the sheets from a total of 6 sheets. i have included the code below. I am unable to enable the field settings in the pivots as this error keeps on appearing.

Please Login or Register  to view this content.

No I actually only have 3 pivot tables, I have about 15 pivot tables all located on different sheets.