Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort function grayed out, how do I ungray it?
The sort function and many others are grayed out in the dropdown menu. I
can't identify anything I did to make this happen, protection seems normal. I need to get back to full functionality so I can work with my data. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort function grayed out, how do I ungray it?
Is the workbook you are using a Shared workbook? If so you need to unshare it before these functions will be active. -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread...hreadid=565340 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort function grayed out, how do I ungray it?
No, it' snot a shared workbook. Basically, I'm working along, doing what I
need to do, sorting at will. Suddenly, and with no reason I can see, I try to make another sort, and several functions including sort are grayed out, and I can't figure out what happened to cause it or fix it. It's odd. "Excelenator" wrote: Is the workbook you are using a Shared workbook? If so you need to unshare it before these functions will be active. -- Excelenator ------------------------------------------------------------------------ Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768 View this thread: http://www.excelforum.com/showthread.php?threadid=56 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index? Match? Function to sort and return value fr diff column in | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions | |||
In Excel 2003 SP1, "sort" on the Data drop-down menu is grayed ou. | Excel Worksheet Functions | |||
Data > Sort function amnesia? | Excel Discussion (Misc queries) |