Hi all, I'm setting up a largeish questionnaire in Excel 2003. So far it has
15 tabs, and a number of these tabs include some questions in multiple choice
format (e.g., agree, disagree, or unsure). I'm using data validation to
create these, and despite my limited skills it was all going well until the
most recent drop-down menu failed to work. I tried re-creating it and it
still didn't work. I copied and pasted it into a new spreadsheet and it
worked fine. Does Excel have a maximum number of data validation cells that
you can create? If so, can anyoen suggest a work-around for this?

Thanks for your help!