Where does Excel store the orientation of PivotFields?

=?Utf-8?B?VmFsZW50aW4=?=

Guest

Posts: n/a

3rd Apr 2006

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?

« updating a table | Bar charts: change color of a bar if value too high? »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Page orientation	Sam	Microsoft Excel Worksheet Functions	1	1st Aug 2008 09:14 PM
Landscape orientation selected but prints Portrait orientation	=?Utf-8?B?QnJlbmRh?=	Microsoft Word Document Management	0	12th Jul 2006 02:11 PM
Excel PivotFields/Items	moglione1	Microsoft Excel Programming	0	8th Jun 2006 04:08 PM
Printing orientation in excel	Peter Adams	Microsoft Excel Misc	0	28th Jan 2004 05:41 PM
mso-page-orientation asp excel	avs	Microsoft Excel Programming	0	23rd Oct 2003 04:01 PM