Renaming Page Fields

[Guest]

I have a macro that cycles through a pivot table page field, then extracting
data from the pivot generated by each page field. Recently, the code entered
a page field value that didn't exist in the underlying data, and I now have
several items in this field that have been renamed. I'm sure someone knows
the issue I'm referring to.

Is there some way I can reverse this? The problem is that when Excel
"renamed" the existing fields, I ended up with fields in the table that do
not exist. There must be some way of getting rid of the renamed fields,
right?

Thanks,
Todd

 

[Guest]

Ok, I figured out how to resolve this issue, but would like to add code to my
routine that checks for the existence of each page field before entering it.
Can anyone make a recommendation?

Todd