in reply to Win32::OLE Range->Group Method

You can't group data in a pivot table in Excel, maybe you need to copy and paste (values only) so that it isn't a pivot table anymore? http://www.ozgrid.com/Excel/grouping-pivot-tables.htm

Replies are listed 'Best First'.
Re^2: Win32::OLE Range->Group Method
by ilikeminis (Initiate) on Nov 02, 2010 at 16:39 UTC
    It is not the pivot table itself (per se) that I am trying to group. Rather, I am trying to group the column field (comprised of dates, none of which are blanks as suggested by the previous link). I am absolutely sure this is possible, as I have both manually achieved this (right click a cell in the field and selected 'Group'), as well as through a very simple vba script (see code at bottom of original post). I have been trying to follow the documentation at MSDN documentation with no success.