data validation

[mattdsc]

I have written a spreadsheet using data validation to control input to
certain fields using a dropdown list for the user to pick from. The master
copy is working fine.

I am aware that if data is copy and pasted into the cells the data
validation is ignored and removed from the cells (I believe this may have
happened)

I have taken action to delete the current data in the cells and re-set up
the data validation however the drop down list does not appear. Furthermore
data validation using a dropdown list does not appear to work anywhere else
within the sheet (but can be set up on other sheets within the file).

I can only assume that somewhere within excel there is the ability to
suppress showing drop down data validation lists in a particular sheet (if so
I cannot find the option) or there is an excel error that is preventing a
drop down data validation list from showing.

Could you please advise on how to display the drop down list or obtain if
this is a known excel error. An explanation of how it occurs would be useful
as the user cannot remember what they did!!

[Max]

> Could you please advise on how to display the drop down list or obtain if
> this is a known excel error. An explanation of how it occurs would be useful
> as the user cannot remember what they did!!

Just some thoughts and empathy ... Recollect some past posts discussing this
phenomena. Experienced it once myself a few years ago in an xl97 file. Could
find no way to re-activate the droplists on that one particular sheet. All
droplists suddenly plain disappeared, just like that. Don't think I did
anything wrong, was just working as usual on the sheet. Had to re-build that
particular sheet on a new sheet. A backup file did help in cutting down the
re-build effort.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mattdsc" wrote:
> I have written a spreadsheet using data validation to control input to
> certain fields using a dropdown list for the user to pick from. The master
> copy is working fine.
>
> I am aware that if data is copy and pasted into the cells the data
> validation is ignored and removed from the cells (I believe this may have
> happened)
>
> I have taken action to delete the current data in the cells and re-set up
> the data validation however the drop down list does not appear. Furthermore
> data validation using a dropdown list does not appear to work anywhere else
> within the sheet (but can be set up on other sheets within the file).
>
> I can only assume that somewhere within excel there is the ability to
> suppress showing drop down data validation lists in a particular sheet (if so
> I cannot find the option) or there is an excel error that is preventing a
> drop down data validation list from showing.
>
> Could you please advise on how to display the drop down list or obtain if
> this is a known excel error. An explanation of how it occurs would be useful
> as the user cannot remember what they did!!

[Max]

Here's a relevant past discussion in google:
http://tinyurl.com/q8uun

Anyway, do hang around awhile for possible drop-ins by others
All the best
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

[mattdsc]

Thanks for the reply, Max.

Much appreciated.


"Max" wrote:

> Here's a relevant past discussion in google:
> http://tinyurl.com/q8uun
>
> Anyway, do hang around awhile for possible drop-ins by others
> All the best
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---

[Max]

You're welcome, Matt!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mattdsc" wrote:
> Thanks for the reply, Max.
> Much appreciated.

[Max]

You're welcome, Matt!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mattdsc" wrote:
> Thanks for the reply, Max.
> Much appreciated.