Pivot Table Grouping

Henry · Apr 3rd, 2002, 04:05 PM

How come Excel won't let me Group Field?

These aren't Calculated.

Mike

daleyman · Apr 3rd, 2002, 04:06 PM

under what conditions and what error does it give you?

Mark W. · Apr 3rd, 2002, 04:40 PM

Quote:

On 2002-04-03 15:05, Henry wrote:
How come Excel won't let me Group Field?

These aren't Calculated.

Mike

Does your field include blanks (empty cells)?

[ This Message was edited by: Mark W. on 2002-04-03 15:50 ]

Dave Hawley · Apr 3rd, 2002, 08:09 PM

Hi Henry

Blank cells within your data and/or Text and Numbers in the same column is the most likely cause. If your field contains dates ensure they are all REAL dates (right aligned).

You should also consider using a Dynamic range as the Source for your Pivot Table as these will elminate the need to include possiby thousands of blank rows in your source data.

http://www.ozgrid.com/Excel/DynamicRanges.htm

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:05 PM	#1
Henry Board Regular Join Date: Mar 2002 Location: Mike T. Posts: 180	How come Excel won't let me Group Field? These aren't Calculated. Mike

Apr 3rd, 2002, 04:06 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	under what conditions and what error does it give you?

Apr 3rd, 2002, 08:09 PM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Henry Blank cells within your data and/or Text and Numbers in the same column is the most likely cause. If your field contains dates ensure they are all REAL dates (right aligned). You should also consider using a Dynamic range as the Source for your Pivot Table as these will elminate the need to include possiby thousands of blank rows in your source data. http://www.ozgrid.com/Excel/DynamicRanges.htm