Error: Unable to set the Orientation property of the PivotField class

Devotchka

New Member
Joined
Jun 8, 2010
Messages
13
I have Excel 2003. I have 2 different data fields being pulled into the area vol_net and vol_gross and for some reason when there is a lot of data the table freaks out and comes up with the orientation error.

With ActiveSheet.PivotTables("PivotTable3").PivotFields("vol_net")
.Orientation = xlDataField
.Caption = "Sum of vol_net"
.Position = 1
.Function = xlSum

The error is on the 2nd line in .Orientation = xlDataField

Any help would be appreciated!
 

Forum statistics

Threads
1,082,607
Messages
5,366,587
Members
400,904
Latest member
ndaines meriabi

Some videos you may like

This Week's Hot Topics

Top