Hi All:
I am trying to group dates in my pivot table without success. I am
using a dynamic name range and there are no blanks fields on the pivot
table or the dynamic data range. In the source data and the pivot table
, I have formatted the date field to show the full day eg
Saturday,January 1, 2005 instead of 1/1/2005.
What can be the possible problem. I am using excel 2003

Perhaps a blank row is included at the end of the pivot table source
range. Or, one of the dates is not being recognized as a real date.

PFL wrote:
Hi All:
I am trying to group dates in my pivot table without success. I am
using a dynamic name range and there are no blanks fields on the pivot
table or the dynamic data range. In the source data and the pivot table
, I have formatted the date field to show the full day eg
Saturday,January 1, 2005 instead of 1/1/2005.
What can be the possible problem. I am using excel 2003



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

The pivot table source is a dynamic range.I checked the format of all
the dates and they are recognised as date format in the pivot table
source and pivot table.

Have you verified that the dynamic range includes only the cells you
expected?
How did you check the format of the dates?

PFL wrote:
The pivot table source is a dynamic range.I checked the format of all
the dates and they are recognised as date format in the pivot table
source and pivot table.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I used the info from your website to construct the dynamic range. The
range includes all cells I expected. Originally It did not due to data
in row 2000. I checked the formats of the data by Format=Cell= Date.
The dynamic range only has 10 rows of data at present

If you'd like to send me the workbook, I can take a look at it. Remove
the capital letters from my posted email address, to get the real address.

PFL wrote:
I used the info from your website to construct the dynamic range. The
range includes all cells I expected. Originally It did not due to data
in row 2000. I checked the formats of the data by Format=Cell= Date.
The dynamic range only has 10 rows of data at present



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html