Normally, simply going back to your data table, selecting the column which contains what you think is numeric data, changing the alignment to General under Format>Cells>Alignment will force Excel to return How to grep two numbers from the same line at different places using bash? This worked for me! Cannot Group that SelectionThe first problem "Cannot Group that Selection" is normally caused by one of two things. have a peek here
During this upgrade there may be some intermittent down time preventing access to the forum or certain features. Then I brought in a column of dates from the ‘real’ data entry sheet, and now the grouping is not functional (“Cannot Group That Selection” error). 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. In that case, you will just have to delete the pivot table and start all over again.
Perhaps we'll spot an issue. > > > > > > *********** > > Regards, > > Ron > > > > XL2003, WinXP > > > > > > "Marion" Hello and welcome to PC Review. 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 I did not have any empty spaces and all of my dates were formatted properly.
You'll be able to ask any tech support questions, or chat with the community and help others. I'm not sure why this happens. Cheers, Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members Pivot Table Grouping Not Working Highlight column A, then push Ctrl+G and click Special then check the Blanks option and click OK.
Here is a quick way to fill those blanks with the value of the cell above. After reformatting the date column you should be able to group on that column. Not the answer you're looking for? great post to read By hiding your dummy data it will not interefere with the rest of your valid data.
If you're having a computer problem, ask on our forum for advice. Cannot Group That Selection Pivot Table 2013 Help! -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com Debra Dalgleish, Jan 21, 2010 #8 Doug Muegge Guest Thank you for the information - I have tried clearing all blanks and Basically, what this means is your column must: Have no blank fields Your data range for your Pivot Table should not exceed past the last row of data. Will not even give me the option to choose month, year,etc.
Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? 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 Excel Pivot Table Group Field Grayed Out Advertisements Latest Threads NES Classic Edition reviewed Becky posted Nov 8, 2016 at 4:59 PM Unable to publish Calendar in Outlook 2007 Anoop Soman posted Nov 8, 2016 at 8:37 AM Excel Cannot Group Columns PFL wrote: > I used the info from your website to construct the dynamic range.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. http://kelcours.com/pivot-table/excel-pivot-table-date-cannot-group-that-selection.html I took out > > > all blanks. Just be sure to select dummy data that cannot be misinterpreted for actual data. Originally It did not due to data in row 2000. Pivot Table Not Grouping Dates
To find out, either sort the Date column and look at the top or bottom for any funnies. To start viewing messages, select the forum that you want to visit from the selection below. While I was developing the spreadsheet, I used some arbitrary dates in the Start Date column, and the grouping worked fine. http://kelcours.com/pivot-table/excel-pivot-table-cannot-group-that-selection.html This column contains only dates.
Are there quick ways to implement the solutions and data-checking such as checking for blank cells in a 13,000 row database? Group Dates In Pivot Table Excel 2013 Yes, my password is: Forgot your password? I have checked > > for blank rows as suggested in this thread.
Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Nov 15th, 2011,12:14 AM #7 gepa New Member Join Date Jan 2008 Posts 4 Re: Pivot Table: “Cannot Group On your pivot table, right click the column you are trying to group and select 'field settings'. That's what's causing the Group function to fail because there's no date there.So you need to go ahead and correct the data range so that the broken lines surround data and Excel Pivot Group By Month And Year Browse other questions tagged microsoft-excel pivot-table or ask your own question.
By mingali 25th Oct 2006 04:25 Thanks DavidHowever, i am still unable to sort out the problem with Tips 18. Possible outcomes of fight between coworkers outside the office Does my electronic parking brake remain engaged if I disconnect the battery? Tax Tolley's Tax Hub Practice Sub-categories Practice strategy General practice Skills Practice strategySponsored Practice Excellence Live: The marketing mindset Practice strategySponsored Coming soon: Turn your practice into a niche firm Think this contact form You can now refresh the pivot and should be able to group.
PFL wrote: > Hi All: > I am trying to group dates in my pivot table without success. Why place camera inside box, during court? Thanks (0) By David Carter 25th Oct 2006 11:48 you have to sort out the Data range in Step 2Ken, The "blank" column definitely proves that Excel is looking at a I clicked on the “Start Date” In the Column Filed area and selected Grouping by Month & Year.
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 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 Why Not Donate. Guest, Aug 18, 2007 #2 Advertisements Guest Guest Tks found the error, was a setting of date "Ron Coderre" wrote: > If Excel can recognize the values as dates, you'll get
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 Not sure what to do next. -- Doug M "Debra Dalgleish" wrote: > There are a few other suggestions for fixing grouping problems here: > > http://www.contextures.com/xlPivot07.html > > > Doug However, I do have blanks in the column, and I've been told that will produce the error I'm getting. More About Us...
No, create an account now. Now push Equals (=) then the Up arrow and finally holding down the Ctrl key push Enter. Sign Up Now! Send payment proof to [emailprotected] 31 days after purchase date.
Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00.
© Copyright 2017 kelcours.com. All rights reserved.