F11 gives runtime error 438

[kenelder]

Selecting data from a worksheet to include in a chart and then pressing F11 to create the chart is a great feature of Excel. But when I do that, I always get "Run-time error 438: Object doesn't support this property or method." That happens on every computer I use in our network at work.

When I then click the Debug button, it highlights the following:
For iP = 1 To ActiveSheet.PivotTables.Count

Can someone explain what's causing the error and what we can do to eliminate it?

[Andy Pope]

Sounds like you have VBA code running when you insert a chart sheet.
The code is expecting a pivot table.

The code is likely to be in an addin or possibly a template.