Data Validation not available

's Computer Specifications

I have an OP who is running 2003 and she says that when she clicks on Data
(in the menu) "Validation" is grayed-out. She has access to a 2000 machine
and has no problem accessing Data Validation on that machine, so she is
doing it right.
Has anyone run into this before? Thanks for your time. Otto

's Computer Specifications

Thanks Debra. I'll pass those questions on. Otto
"Debra Dalgleish" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Is she opening the same workbooks in both version of Excel?
> Does this occur for all workbooks?
>
> If only for specific workbooks, are they protected? Are there macros?
> Is the security level in both versions the same?
>
> Otto Moehrbach wrote:
>> I have an OP who is running 2003 and she says that when she clicks on
>> Data (in the menu) "Validation" is grayed-out. She has access to a 2000
>> machine and has no problem accessing Data Validation on that machine, so
>> she is doing it right.
>> Has anyone run into this before? Thanks for your time. Otto
>>
>>
>
>
> --
> Debra Dalgleish
> Contextures
> http://www.contextures.com/tiptech.html
>

's Computer Specifications

Is she opening the same workbooks in both version of Excel?
Does this occur for all workbooks?

If only for specific workbooks, are they protected? Are there macros?
Is the security level in both versions the same?

Otto Moehrbach wrote:
> I have an OP who is running 2003 and she says that when she clicks on Data
> (in the menu) "Validation" is grayed-out. She has access to a 2000 machine
> and has no problem accessing Data Validation on that machine, so she is
> doing it right.
> Has anyone run into this before? Thanks for your time. Otto
>
>

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

's Computer Specifications

Is the sheet protected?

--
Regards,
Tom Ogilvy

"Otto Moehrbach" wrote:

> I have an OP who is running 2003 and she says that when she clicks on Data
> (in the menu) "Validation" is grayed-out. She has access to a 2000 machine
> and has no problem accessing Data Validation on that machine, so she is
> doing it right.
> Has anyone run into this before? Thanks for your time. Otto
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
custom data validation on cells with data validation values	AKrobbins	Microsoft Excel Worksheet Functions	2	21st Jun 2011 04:20 PM
Data Validation -> Validation list is larger than the cell width	Barb Reinhardt	Microsoft Excel Programming	1	4th Mar 2010 08:24 PM
Crazy Data Validation ... List Validation Not Working	TW Bake	Microsoft Excel Programming	1	29th Mar 2007 02:41 AM
data validation invalid in dynamic validation list	ilia	Microsoft Excel Programming	0	7th Nov 2006 12:54 PM
When pasting data into a column with data validation I lose validation check	Brad	Microsoft Excel Misc	5	17th Apr 2004 01:11 PM