modify calculated field (pivot) with macro

Hi all,

How can I modify the formula of a calculated field by using a macro? I have about 20 calculated fields that need to be changed, which is quite time consuming.

The formula of the calculated field "AUR" in the pivot "Last Year" would be something like this:

Please Login or Register  to view this content.

and would need to be changed to:

Please Login or Register  to view this content.

Can this be done with code?

If I record a macro changing the field title I get something like this;

Please Login or Register  to view this content.

Don't know if that helps or not.

That seems to work indeed! Do you also happen to know how to change the calculated field's name not just it's formula? It only let's me add a new calculated field, but not change its name...

I'm not sure if you can. You may need to delete it and re-add with the new name.

which is exactly what creates so much work...

Record a macro of the delete and the add and see if that helps you.

If this is only a one-off then you might be quicker just spending 20 minutes doing it the old-fashioned way.