I have an EXCEL 2013 pivot table to which I am trying to datafields but I keep getting a runtime 9 error at the red text.
The data for the pivot table is a named range (AAA) that has been added to the datamodel.
I have simply recorded a macro and changed activesheet (ws15) & pivot table (uu) to my variables.

Please Login or Register  to view this content.
Also tried the code like this: where pvt1 = my pivot table
Please Login or Register  to view this content.
Anyone have a clue as to what the problem is?

Any assistance appreciated.
Thanks.