Date grouping in Pivot Table
 

I have an addin that changes text in the format "Jan 2005" to an actual date
(1/1/2005). That works just fine. Now here is the problem. If I have a pivot
table attached to the data that I just converted, when I refresh the pivot
table (I get the data has changed message) the text dates switch to actual
dates. Excel however will not let me group on those dates. If I refresh the
table again I once again get the data has changed message and now I can group
on the dates. Am I missing something here. In OLAP terms it seems to require
a two pass calc, without performing doing it.

I am using Excel 2000...

--
Thanks In Advance...

Jim Thomlinson

Date grouping in Pivot Table
 

I've noticed the same thing in Excel 2002 and Excel 2003, so whatever
the problem is, it hasn't been fixed.

Jim Thomlinson wrote:
I have an addin that changes text in the format "Jan 2005" to an actual date
(1/1/2005). That works just fine. Now here is the problem. If I have a pivot
table attached to the data that I just converted, when I refresh the pivot
table (I get the data has changed message) the text dates switch to actual
dates. Excel however will not let me group on those dates. If I refresh the
table again I once again get the data has changed message and now I can group
on the dates. Am I missing something here. In OLAP terms it seems to require
a two pass calc, without performing doing it.

I am using Excel 2000...



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Date grouping in Pivot Table
 

Excel is the worst spreadsheet I have ever used... with the exception of
every other spreadsheet I have ever used... :) I guess I will just have to
learn to live with it...

"Debra Dalgleish" wrote:

I've noticed the same thing in Excel 2002 and Excel 2003, so whatever
the problem is, it hasn't been fixed.

Jim Thomlinson wrote:
I have an addin that changes text in the format "Jan 2005" to an actual date
(1/1/2005). That works just fine. Now here is the problem. If I have a pivot
table attached to the data that I just converted, when I refresh the pivot
table (I get the data has changed message) the text dates switch to actual
dates. Excel however will not let me group on those dates. If I refresh the
table again I once again get the data has changed message and now I can group
on the dates. Am I missing something here. In OLAP terms it seems to require
a two pass calc, without performing doing it.

I am using Excel 2000...



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html