Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2007 PivotTable Type Mismatch for records more than 65536
Hi,
I'm new in this discussion group and will appreciate if someone can help me in finding a workaround with the problem having with creating pivottable in excel 2007. I have the following code and get Type Mismatch error at line "Set PivC...". This pivottable is based off 200,000 records in a worksheet called "Data". I can maually create the pivottable without any error message. I have found that the error message is generated when I use data records of more than 65536. Upto 65536 records, code runs fine. Has anyone run in to problem like this? Will really appreciate your help. Thanks. Sub CreateSpendPivotTable() ' ' CreateSpendPivotTable Macro ' Dim wB As Workbook Dim PivC As PivotCache Dim PivT As PivotTable Application.DisplayAlerts = False Worksheets("Data").Select Set PivC = ActiveWorkbook.PivotCaches.Create _ (xlDatabase, Range("A1").CurrentRegion) Sheets("%Spend Matching").Select Set PivT = PivC.CreatePivotTable _ (TableDestination:=Worksheets("%Spend Matching").Range("B2"), _ TableName:="PivotTable1") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel spread sheet larger than 65536 records | Excel Discussion (Misc queries) | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Type Mismatch when creating a pivottable macro | Excel Programming |