macro to expand and collapse a pivot field failing.

Hello, I thought I would try to write a macro to expand and collapse a pivot field. I recorded both expanding and collapsing the pivot field in the macro recorder and tried to combine the two with an if statement but it is failing on the first line of the macro with a "Run time erro 1004: application defined or object defined erro" message. Can someone tell me why as I have no idea.

Please Login or Register  to view this content.

I'm not sure exactly what you are trying to expand/contract. Have you grouped some items? The ShowDetail = true/false works for pivot items but I don't think it works for whole fields.

If you want to toggle showing/hiding the Year field you could use something like

Please Login or Register  to view this content.

If this isn't what you need, perhaps you could upload an example file.