Where does Excel store the orientation of PivotFields?

V

Valentin

Hi there,
I'm trying to find out where Excel stores the orientation of a PivotField,
especially once it has been draged into position.

Right now I'm using the
AcitveChart.PivotLayout.PivotTable("TableName").PivotFields() Function to get
a collection of all Fields within that Table. But even though all Fields are
in the collection each of them has the orientation "xlHidden" regardless
where I dragged them at the chart. The display of the fields within the
charts works perfectly fine.

Can Somebody Help me please?
 

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

Error 2007 0
Pivot Table Clear All Fiels 3
Problem creating PivotTable from ADO recordset using VBA 0
Programming a pivot 0
Adding Report Filters to Excel Pivot Tables via VB. 1
Unable to get the PivotFields property of the PivotTable Class 2
Excel Program Glitch? 5
Run-time error 1004 ! What is the problem ? 0

Top