I have a pivot table with multiple data fields. However, I do not
want to display all the data fields at the same time. I would like to
write a macro which loops through all the data fields and refreshes
the table upon doin so. At any given time I only want one data field
to be displayed.

My data fields are named Aco, Bco, Cco, and Dco.

So if Aco is shown, I want Bco, Cco and Dco to be hidden. Is ther
any easy way to put these in a loop so that I can do this?

TS