I have a workbook that I've been working with for a long time, and I'm trying to add a dropdown list with a data validation to one of my worksheets. Data validation works in every other worksheet, except for one.
Any ideas?
Thanks for the help.
I have a workbook that I've been working with for a long time, and I'm trying to add a dropdown list with a data validation to one of my worksheets. Data validation works in every other worksheet, except for one.
Any ideas?
Thanks for the help.
I have found a solution.
There was a problem in Excel97 with Window>Freezing Panes which did not effect me.
I am using Excel2003. And there was a data validation error. So I saved a copy and opened excel, and then instead of 'open'ing the file, I chose 'open and repair'.
worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks