Excel 2007, Pivot Table,

V

Vadim Gerya

Hi !

If you try to set ProperyOrder in PivotTable by using
1) OLAP tools -> Property Fields -> Choose property fields for dimentions
or even
2) VBA method, -> AddMemberPropertyField(Property, PropertyOrder,
PropertyDisplayedIn)
you fails.

PropertyOrder parameter is not changed despite any efforts from my side. So
I can not group fileds properties in required way...
It works correct in Excel 2003

Does any body investigate this bug and have workaround to share ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table compatibility 0
Excel Pivot Table, Property Fields 0
Adding Report Filters to Excel Pivot Tables via VB. 1
Alternatives to MS Query for Pivot Tables & Cubes 0
XLS 2007 pivoting off SSAS 2005 > odd behavior 0
Pivot Table accessing data from OLAP cube 0
Macro for Pivot in MS Excel 2003 vs 2007 1
Pivot Table Page Field value from cell in another worksheet 3

Top