Not sure if DV is your problem but you may be better of using a usefrom for
user input.

see workbooks section at:

http://au.geocities.com/excelmarksway



"Ant" wrote:

Does anyone know if data validation uses a lot of space. I have a file which
was about 2MB and now that I have put in a lot of data validation selections
it is now up to 8MB. The idea was to us DV to make the file safer for input
reasons but now it is so big it is a little unstable which sort of defeats
the purpose.