Re: Why aren't dates always available to group in pivot tables?
- From: "Ken Wright" <ken.wright@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 31 Dec 2005 16:14:55 -0000
You cannot have any blanks, text, or non date entries in a date field if you
want to be able to group the dates.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"cs02000" <cs02000.20vpe8@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:cs02000.20vpe8@xxxxxxxxxxxxxxxxxxxxxxx
>
> I played around with the grouping for a while and found that if I
> deleted a couple of date entries (to cause the error) I was unable to
> regroup the date field after restoring the deleted dates.
>
>
> --
> cs02000
.
- References:
- Prev by Date: Re: Chart Series
- Next by Date: Re: Why aren't dates always available to group in pivot tables?
- Previous by thread: Re: Why aren't dates always available to group in pivot tables?
- Next by thread: Re: Why aren't dates always available to group in pivot tables?
- Index(es):
Relevant Pages
|
