run-time error 1004 Unable to get the PivotFields property of the PivotTable Class

[cwelt21]

I'm running into a strange problem, for many years I have used these excel macros and all of a sudden I started to receive errors that only appear on one computer. This macro and pivot issue doesn't exist on any other computer I have tried. So excel was uninstalled and a fresh clean updated copy has been installed and the issue still exists.

run-time error 1004 Unable to get the PivotFields property of the PivotTable Class

VBA notes the error being located with the code of:

ActiveSheet.PivotTables(1) .PivotFields("count of quantity") .Function = xlSum

Any ideas of why I would have this issue on one computer only?.. Also please note this worked fine for many years on this same computer and then one day just developed this problem out of nowhere.

 

[toci1980]

It is an old topic but I have the same problem here. Have you resolved your issue?

 

[cwelt21]

i was able to get around the issue by replacing count with sum, it seams to work differently on newer versions of excel.

 

[Bmort]

It is an old topic but I have the same problem here. Have you resolved your issue?

Same here- different between versions of excel. Using Office 365 on one machine and 2013 on another. It works in Office 365, but fails on 2013. Did you solve your issue?