Results 1 to 1 of 1

pivottables: renamed fields and renamed data

Threaded View

  1. #1
    Registered User
    Join Date
    08-11-2007
    Posts
    44

    pivottables: renamed fields and renamed data

    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
    Last edited by lalbatros; 09-04-2007 at 03:32 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1