Hello
A few facts first:
In pivot tables it is possible to rename a field just by overwriting it: for example a row header.
Similarly, it is also possible to rename data: for example the possible values of a row header field.
It is clear that excel remembers the original names and values.
Otherwise refreshing the table would scramble the whole table,
and also the field-list shows the original names of the fields.
My question:
How would it be possible to read and/or to write -in VBA- the correspondance between original names/data and the newly given names/data?
Is there maybe some property available for that?
Thanks for your suggestions
Bookmarks