| 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 |
| 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)
Threaded Mode
