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