| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Why is my sort menu option disabled?
I exported a Crystal Report to Excel 2002, but when I try to sort the data,
the sort menu is greyed-out/disabled. Anyone know why? Thanks in advance! |
|
#2
|
|||
|
|||
|
Why is my sort menu option disabled?
Is the worksheet protected?
Do you have multiple worksheets selected/grouped? Valerie M wrote: I exported a Crystal Report to Excel 2002, but when I try to sort the data, the sort menu is greyed-out/disabled. Anyone know why? Thanks in advance! -- Dave Peterson |
|
#3
|
|||
|
|||
|
Why is my sort menu option disabled?
It is not protected, but I do have two worksheets, since it is 97000 records
long... I was finally able to get it to work by viewing the second worksheet for some reason. It's almost like I had to view the first worksheet and then view the second worksheet to enable it. "Dave Peterson" wrote: Is the worksheet protected? Do you have multiple worksheets selected/grouped? Valerie M wrote: I exported a Crystal Report to Excel 2002, but when I try to sort the data, the sort menu is greyed-out/disabled. Anyone know why? Thanks in advance! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel subtotals, add a sort option, and BOLD the function answers | New Users to Excel | |||
| disable customize option when right click on menu bar | Excel Discussion (Misc queries) | |||
| XML Data menu option -- not listed / available. How do you fix thi | Excel Discussion (Misc queries) | |||
| In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions | |||
| XML Source Menu Item disabled?? File version?? | Excel Discussion (Misc queries) | |||
Hybrid Mode
