excel.advanced.course - Pivot Table

Resolved · Low Priority · Version Standard

Mon 28 Jan 2008, 11:22 Delegate Hari said...

Hari has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Pivot Table

How can Objects, Method, Properties aspect of VBA related to Pivot Table.

Also, can a list fuction used on Pivot table?.

Sun 10 Feb 2008, 09:44 Trainer Stephen said...

RE: Pivot Table

Hi Hari

Thankyou for your question

The object model that relates to the PivotTable contains the following objects

PivotTable
PivotCache
PivotField
PivotItems
PivotChart

Each object has a range of properties and methods.

For example the PivotField object has an orientation property which is used to specify if it is in a column, row, pagefield, or data. The same object has a number of methods including Delete, AddPageItem and autosort

As to your query about list functions could you clarify what you wish to do with the list box and how you want it to relate to the PivotTable

Regards

Stephen

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips