Data Validation doesn't work on 1 sheet only

I have a Data Validation drop down that has stopped working in one sheet
only.
I made a new Data Validation in the same book, but in another sheet, and it
works.
I have checked Tools>Options>View>Objects and SHOW ALL is checked.
Any ideas??
The drop down doesn't show and the error alert doesn't pop up if I enter an
invalid entry(It is turned on)
Joe

Have you tried Data / Validation whilst in those cells, to confirm that it
is fact pulling from where you think it is.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
news:eAQn8R0GFHA.3244@TK2MSFTNGP09.phx.gbl...
> I have a Data Validation drop down that has stopped working in one sheet
> only.
> I made a new Data Validation in the same book, but in another sheet, and
it
> works.
> I have checked Tools>Options>View>Objects and SHOW ALL is checked.
> Any ideas??
> The drop down doesn't show and the error alert doesn't pop up if I enter
an
> invalid entry(It is turned on)
> Joe
>
>
>

Yes I have.
In another sheet, I have a named list called "sites".
When I select a cell and do Data / Validation, it is there(=sites).

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:eFFERc0GFHA.2744@tk2msftngp13.phx.gbl...
> Have you tried Data / Validation whilst in those cells, to confirm that it
> is fact pulling from where you think it is.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
> news:eAQn8R0GFHA.3244@TK2MSFTNGP09.phx.gbl...
>> I have a Data Validation drop down that has stopped working in one sheet
>> only.
>> I made a new Data Validation in the same book, but in another sheet, and
> it
>> works.
>> I have checked Tools>Options>View>Objects and SHOW ALL is checked.
>> Any ideas??
>> The drop down doesn't show and the error alert doesn't pop up if I enter
> an
>> invalid entry(It is turned on)
>> Joe
>>
>>
>>
>
>

How sensitive is your data? I'm curious now, so happy to take a look at the
book for what it is worth, but can't promise anything. You could always
delete the actual data and just leave a sheet that works and one that
doesn't and then mail me a copy. Your call.

Need to take the NOSPAM bit out of my email address though.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
news:uKIwMh0GFHA.584@TK2MSFTNGP14.phx.gbl...
> Yes I have.
> In another sheet, I have a named list called "sites".
> When I select a cell and do Data / Validation, it is there(=sites).
>
> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
> news:eFFERc0GFHA.2744@tk2msftngp13.phx.gbl...
> > Have you tried Data / Validation whilst in those cells, to confirm that
it
> > is fact pulling from where you think it is.
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
--
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
--
> >
> > "lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
> > news:eAQn8R0GFHA.3244@TK2MSFTNGP09.phx.gbl...
> >> I have a Data Validation drop down that has stopped working in one
sheet
> >> only.
> >> I made a new Data Validation in the same book, but in another sheet,
and
> > it
> >> works.
> >> I have checked Tools>Options>View>Objects and SHOW ALL is checked.
> >> Any ideas??
> >> The drop down doesn't show and the error alert doesn't pop up if I
enter
> > an
> >> invalid entry(It is turned on)
> >> Joe
> >>
> >>
> >>
> >
> >
>
>

"Hi Joe - The workbook has corrupted, and the error repair facility
specifically lists Data Validation as having been lost. What version Excel
do you have?"

Excel 2003

"File / Open - select workbook - on the 'open' button bottom right on the
dialog box you will see a dropdown arrow - click and choose 'open and
repair'"

Success!
Thanks so much Ken,
Joe


"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:OCxHm%230GFHA.3244@TK2MSFTNGP09.phx.gbl...
> How sensitive is your data? I'm curious now, so happy to take a look at
> the
> book for what it is worth, but can't promise anything. You could always
> delete the actual data and just leave a sheet that works and one that
> doesn't and then mail me a copy. Your call.
>
> Need to take the NOSPAM bit out of my email address though.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
> news:uKIwMh0GFHA.584@TK2MSFTNGP14.phx.gbl...
>> Yes I have.
>> In another sheet, I have a named list called "sites".
>> When I select a cell and do Data / Validation, it is there(=sites).
>>
>> "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
>> news:eFFERc0GFHA.2744@tk2msftngp13.phx.gbl...
>> > Have you tried Data / Validation whilst in those cells, to confirm that
> it
>> > is fact pulling from where you think it is.
>> >
>> > --
>> > Regards
>> > Ken....................... Microsoft MVP - Excel
>> > Sys Spec - Win XP Pro / XL 97/00/02/03
>> >
>>
>> --------------------------------------------------------------------------
> --
>> > It's easier to beg forgiveness than ask permission :-)
>>
>> --------------------------------------------------------------------------
> --
>> >
>> > "lunker55" <this_is_not_my_email_address@hotmail.com> wrote in message
>> > news:eAQn8R0GFHA.3244@TK2MSFTNGP09.phx.gbl...
>> >> I have a Data Validation drop down that has stopped working in one
> sheet
>> >> only.
>> >> I made a new Data Validation in the same book, but in another sheet,
> and
>> > it
>> >> works.
>> >> I have checked Tools>Options>View>Objects and SHOW ALL is checked.
>> >> Any ideas??
>> >> The drop down doesn't show and the error alert doesn't pop up if I
> enter
>> > an
>> >> invalid entry(It is turned on)
>> >> Joe
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
>