ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sort function grayed out, how do I ungray it? (https://www.excelbanter.com/excel-discussion-misc-queries/101521-sort-function-grayed-out-how-do-i-ungray.html)

Stan Wilcox

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.

Excelenator

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


Stan Wilcox

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



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

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