Hi all,

I got some help with a data validation issue yesterday. See link:

http://www.excelforum.com/excel-gene...alidation.html

Original file that I adapted is here.

http://www.excelforum.com/attachment...-sample-1-.xls

The problem I'm having is that the data validation - which references named ranges - stops when the workbook is closed. I open the file again and the drop down lists stop working. I go back into data validation and the formulas are all still there, then the drop down boxes start working again.

Is there any reason why this would happen? I'm trying to avoid having to go into data vaildation every time I open the workbook.

I'm using 2010 - it's possible that the document will get used on a machine running 2007. The named ranges are all on this file.

Cheers,
Rob