Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
les8
 
Posts: n/a
Default "Cannot Group That Selection" in a Pivot Table.

Occasionally I get "Cannot Group That Selection" when working with a Pivot
Table. Any idea why?

Thanks,
Les8
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default "Cannot Group That Selection" in a Pivot Table.

Usually, it's because one of the values in that field is either text or empty.

I'd start looking there.

les8 wrote:

Occasionally I get "Cannot Group That Selection" when working with a Pivot
Table. Any idea why?

Thanks,
Les8


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Group Field in Pivot Table €“ Not Enough Room Mary Ann Excel Discussion (Misc queries) 2 July 15th 05 08:22 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 07:24 PM
Pivot table will not group a date field Mary Excel Discussion (Misc queries) 2 February 17th 05 02:53 AM
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 08:41 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"