And until you've converted all cells from text-looking-like-time to actual time (i.e. If you have formatting that overide the default alignment on that column you can check by fomatting one of the cells as a number. Obviously you would do this so when you add more information to your table it would automatically be included in your Pivot Table the moment you refresh it. Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel http://amigasuperbit.com/pivot-table/pivot-table-error-cannot-group-that-selection.html
This is because Excel does not know what it should do with the one blank cell in regards to grouping with date cells. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,06:19 PM #2 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 Register To Reply 01-04-2005,06:06 PM #4 Debra Dalgleish Guest Re: Cannot Group that selection Problem Have you verified that the dynamic range includes only the cells you expected? The time now is 07:49 AM.
Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #2 Pesky Weasel View Profile View Forum Posts OZMVP Join Date 7th February 2003 Location Kewarra Beach, Cairns - TNQ Posts Send payment proof to [emailprotected] 31 days after purchase date. Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #4 Dave Hawley View Profile View Forum Posts Visit Homepage Administrator Join Date 24th January 2003 Location Australia Posts 31,973 Hi Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #4 Dave Hawley View Profile View Forum Posts Visit Homepage Administrator Join Date 24th January 2003 Location Australia Posts 31,973 Hi
After reformatting the date column you should be able to group on that column. Thanks Paul Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Page 1 of 2 12 Last Jump to page: « Previous Thread | Next Thread » Like Templates and Calculators The Way of the Weasel Download Ivan & Colo's HTML Maker Here 101 Excel Hacks - Great New Book Huge Savings on Excel Training February 11th, 2004 #3 Pivot Table Not Grouping Dates When I click "Group Selection" on my invoice dates, I just get the message "Cannot group that selection".
Grouping pivot tables by text is a similar feature that allows pivot tables to be grouped by text values. Thanks. share|improve this answer answered Oct 8 '12 at 16:08 nutsch 1,478613 1 You may need to remove and re-add the field to the Pivot Table before it will group, I http://www.ozgrid.com/Excel/grouping-pivot-tables.htm Blank cells are also considered to be invalid dates, so you must make sure that there are no blanks.
I have a Pivot Table based on the data entry sheet. Pivot Table Grouping Not Working To start viewing messages, select the forum that you want to visit from the selection below. Here is a quick way to fill those blanks with the value of the cell above. This is the reason I come to this site.
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,06:28 PM #4 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/cannot-group-data-for-date-fields-in-a-pivot-table/fe380d63-446d-e011-8dfc-68b599b31bf5 For more information about grouping pivot tables by text, see Expert Skills Lesson 5-19 Group by text. Excel Pivot Table Group Field Grayed Out Any advice for getting the pivot table to ignore the blanks? Cannot Group That Selection Excel 2007 Pivot Table What can be the possible problem.
This column contains only dates. weblink Any advice you have for a more elegant solution is welcome. What is the most efficient & fastest way to speed up the installation of packages with thousands of items? The temptation is always there to make your data range for your Pivot Table extend well past the last row of information in your table and thus include many blank cells. Excel Cannot Group Columns
Remove the capital letters from my posted email address, to get the real address. Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Into Web Pages | Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel Quick For more details on dates & numbers seen as text see:Convert Dates || Excel Calendar for Valid Dates || Excel Date and Times || Converting Text Numbers to Real Numbers Pivot navigate here I am using excel 2003 Register To Reply 01-04-2005,06:06 PM #2 Debra Dalgleish Guest Re: Cannot Group that selection Problem Perhaps a blank row is included at the end of the
Is there a word for being sad about knowing that the things that make you happy will eventually go away What's the pun about? Cannot Group That Selection Pivot Table 2013 For more about grouping pivot tables by dates, see Expert Skills Lesson 5-20 Group by date. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.
Should I report it? Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money Special! Start Date is also used as the data field (Count of Start Date). Group Dates In Pivot Table Excel 2013 The ages range from 5 to 16 years.If you want to group the ages into the age ranges 5-8 years, 9-12 years and 13-16 years, you can this as follows:Right click
Grouping Pivot Table Data. The time now is 20:49. Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. his comment is here Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not
Zener diodes in glass axial package - not inherently shielded from photoelectric effect? Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Are there quick ways to implement the solutions and data-checking such as checking for blank cells in a 13,000 row database? If you don't like Google AdSense in the posts, register or log in above.
Advanced Excel Integration XL-Dennis corner in the Excel-world OTHER STUFF DAVE HAWLEY FOUNDATION Newsletters Competitions HAV-A-CHAT Book Suggestions & Reviews Test Area Excel Development & Consultancy EXCEL SEARCH & RESOURCES Excel I did not have any empty spaces and all of my dates were formatted properly. Can you tell me some possible causes of this error? You may have to widen your column a little, to actually see whether your data is left aligned (text) or right aligned (numbers).
Ozgrid Retains the Rights to ALL Posts and Threads Microsoft Excel Training- From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS Grouping Excel Pivot Tables | | Information Helpful? Pivot tables won't allow you to group dates if there are any invalid dates within the data source. Results 1 to 4 of 4 Thread: [Solved] Pivot Tables : “Cannot Group That Selection” error Thread Tools Show Printable Version Search Thread Advanced Search February 11th, 2004 #1 steveski Backup copies of the file worked, but every time I went to the most recent, or copied the data from the most recent to the backup, the table messed up.
To start viewing messages, select the forum that you want to visit from the selection below. This column contains only dates. ExcelFunctions.net Search Site: + Home » Excel-Pivot-Table-Tutorial » group-pivot-tablePivot Table Tutorial Part 3 - Group A Pivot Table in Excel When analysing data in Excel, it is often useful to group However, I do have blanks in the column, and I've been told that will produce the error I'm getting.
Now push Equals (=) then the Up arrow and finally holding down the Ctrl key push Enter. Excel Video Tutorials / Excel Dashboards Reports February 11th, 2004 #2 Pesky Weasel View Profile View Forum Posts OZMVP Join Date 7th February 2003 Location Kewarra Beach, Cairns - TNQ Posts Fill Blank Cells Within a List Let's say you have a list of entries in column A and within the list you have many blank cells. Originally It did not due to data in row 2000.
asked 4 years ago viewed 7428 times active 4 years ago Related 1Excel pivot table group all months by year2Dates not recognized as dates in pivot table pulling directly from SQL Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 11th, 2013,02:00 AM #9 ahamed Board Regular Join Date Jan 2011 Posts 112 Re: Pivot Table: “Cannot Group The dynamic range only has 10 rows of data at present Register To Reply 01-04-2005,11:06 PM #6 Debra Dalgleish Guest Re: Cannot Group that selection Problem If you'd like to send