ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why is my sort menu option disabled? (https://www.excelbanter.com/excel-discussion-misc-queries/51405-why-my-sort-menu-option-disabled.html)

Valerie M

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!

Dave Peterson

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

Valerie M

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



All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com