I have a question. In Excel 220,222,223 and 224 I can only view and listen to the intro and review. When I click on anything else I am prompted to purchase the program which I have already done. Please help. Thank you.
Reply from Richard Rost:
It's possible you were TIMED OUT. If you don't click on anything for 20 minutes, the web site will automatically log you out. Just click on the LOGON button and reload the course.
Richard: were you able to work Denise's problem out? I get the same "Cannot group that selection." message in both Excel 2003 and 2007. Excel 224, Lesson 02, minute 2:59. I right click on Date header, then click Groupand Show Detail in 2003 and Group in 2007 (there is no Group and Show Detail intermediate selection in 2007)and I get the error message in both cases. Any ideas? Finlay
I am experiencing the same problem as Denise. When I create the Pivot table on my own I am getting the "Cannot group that selection" error as well. If I use the data set that you created, I don't have that problem. Have you figured this one out? thanks!! Ro
Denise, without seeing exactly what you're doing, I really can't say what the problem is. What time-index in the video are you getting to when you get this problem? I'll see if I can recreate it. Since nobody else has complained here about this (and I know several thousand people have taken this class) it's got to be something you're doing different... but don't worry, we'll figure it out.
I have followed the instructions exactly however when I right click on the Date field and select Group and Show Detail option / Group I get the following error message - "Cannot group that selection." What can the problem be?