ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Validation not available (https://www.excelbanter.com/excel-programming/386118-data-validation-not-available.html)

Otto Moehrbach

Data Validation not available
 
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



Otto Moehrbach

Data Validation not available
 
Thanks Debra. I'll pass those questions on. Otto
"Debra Dalgleish" wrote in message
...
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




Debra Dalgleish

Data Validation not available
 
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


Tom Ogilvy

Data Validation not available
 
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





All times are GMT +1. The time now is 05:31 PM.

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