Select Review 6th Tab from the left -options are applicable for Office Click on Share Workbook. Uncheck the option named as "Allow changes by more than one user at the same time. This also allows workbook merging". Click OK. Saved the excel spreadsheet and check the results.
Upload to the SharePoint document library and check the results. You will find the option of "Data Validation" is now enable. Yippee--Expression from the user as his issue has been resolved. Posted by Anmol at PM. Labels: Data validation greyed out;Excel validation greyed out. Anonymous May 11, at PM. Anmol April 9, at AM. What's new New posts New Excel articles Latest activity. New posts. Excel Articles Latest reviews Search Excel articles.
Log in Register. Search titles only. Search Advanced search…. Search forums. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled.
For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Data Validation Greyed Out. Thread starter coliervile Start date Jul 22, Joined May 19, Messages Good day to everyone, I'm working in Excel Improve this question.
Dan Dan 21 1 1 silver badge 2 2 bronze badges. Are there merged cells involved? Because those can mess up some functions. Is the worksheet protected or set as shared? You said "The sheet is not locked or protected, but it is shared. Add a comment. Active Oldest Votes. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end.
0コメント