Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unable to set the orientation property of Pivitfield class
Hi I wud really appreciate if somebody helps me by telling me why do i get this runtime error whn i try to pull out data in my excel.I m using Ms.Excel 2000. and my code is like this With pvtReport ..PivotFields("ConfWeight").Orientation = xlDataField ..PivotFields("Sum of ConfWeight").NumberFormat = "#,##0" ..PivotFields("Month").Orientation = xlRowField ..PivotFields("CompanyName").Orientation = xlRowField ..PivotFields("ContactName").Orientation = xlRowField ..PivotFields("PrimarySalesRep").Orientation = xlRowField ..PivotFields("SecondarySalesRep").Orientation = xlRowField ..PivotFields("PartnerManager").Orientation = xlRowField ..PivotFields("Reseller").Orientation = xlRowField ..PivotFields("ProductFamily").Orientation = xlRowField ..PivotFields("Probability").Orientation = xlColumnField End With I run this for a period of First day of quarter till Today's date i get the result . But whn i try to run it for the entire quarter i get the error. anyhow whn i remove .PivotFields("ProductFamily").Orientation = xlRowField it runs fine for the full quarter. Please help annu -- anu_manu ------------------------------------------------------------------------ anu_manu's Profile: http://www.excelforum.com/member.php...o&userid=31510 View this thread: http://www.excelforum.com/showthread...hreadid=518414 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to set the formula property of the series class | Charts and Charting in Excel | |||
Unable to set the XValues property of the Series class | Charts and Charting in Excel | |||
Unable to get the Open property of the Workbooks class | Excel Programming | |||
Unable to Set LeftFooter Property Class PageSetup (ASP) | Excel Programming | |||
Error 1004 - unable to set the orientation of the page setup class | Excel Programming |