| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table date grouping | Excel Discussion (Misc queries) | |||
| grouping date in pivot table | New Users to Excel | |||
| Grouping Date Fields in Pivot Table | Excel Discussion (Misc queries) | |||
| Grouping By Date in Pivot Table | Excel Worksheet Functions | |||
| Pivot table-date grouping | Excel Discussion (Misc queries) | |||
![Jim Thomlinson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
