More than 8000 column in a TCD - VBA

[siocnarf]

Hi,

I am using Excel 2003.

I am trying to add a date field in my column and then group it as a date. Th field date is format like this:
<TABLE style="WIDTH: 91pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=121 border=0><COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><TBODY><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl65 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 91pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=right width=121 height=17>2011-05-11 16:06</TD></TR></TBODY></TABLE>

My problem is when I am trying to add the field as a column then excel is saying I cannot add more that 8000 column. As when it will be group, I will not have more than 31 column

With ActiveSheet.PivotTables(P_StrTableName).PivotFields( _
        VDataCol7(0))
        .Orientation = xlColumnField
        .position = 1
End With
 
pt.PivotFields(VDataCol7(0)).LabelRange.Group , By:=1, Periods:= _
        Array(False, False, False, True, False, False, False)

What can I do?


Thanks!

Francois

 

[epamias]

I have the same issue I have 8000+ columns that I need to group but I can't do it. The only way I can, is to add it to the row section, group it, then drag it up to the column section. I need that in VBA if anyone can help?