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