Identifying the first displayed column in a Pivot Table

[r3iuk]

I have a pivot table with the Allow Pivoting option checked, so a user can move the columns about.

Is it possible from within a macro to identify which column has been set to be the first column in the table.  I've tried using the Table Properties.DisplayOrder member but this seems to be unpopulated.

Thanks for any help you can provide.

[bgerchikov · Accepted solution]

Hi Mike,

To resolve this problem there are two options:

1. Doesn't allow user to save the document

2. If you want to use macro, the table has to rebuild from scratch

Good luck!