UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Data Validation    
 
   
abb
post Dec 6 2007, 07:04 PM
Post #1

UtterAccess Enthusiast
Posts: 51
Hi,

I am working on a excel file which as many spread sheets. This file is crated by different emplyee and he is no more in the office. I have a problem with this file

There is a column called "Status" which we can enter only data from drop down. This list is in different sheet of same file. Now the users want to have another status to be included in the drop down. when i go for "validation" option in "Data" menu, it is disabled.

Can any one please let me know why is validation disabled.

Thanks
Go to the top of the page
 
+
KingMartin
post Dec 7 2007, 12:34 AM
Post #2

Retired Moderator
Posts: 10,959
From: Prague,CZ / Kiev,UA
Hi,

maybe a protected sheet?

Martin
Go to the top of the page
 
+
abb
post Dec 7 2007, 09:21 AM
Post #3

UtterAccess Enthusiast
Posts: 51
Thanks for the reply, even all the options in "protection" are disabled except "Protect shared workbook"
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 07:10 AM