Hi folks -

Can anyone help? I have a spreadsheet with a series of drop-down lists. I have named these lists for the sake of ease.

In a seperate workbook I have used some of these named drop-down lists - however, they only work when the original workbook is open - when it is closed the drop-downs disappear.

Is there a way of fixing this problem or am I going to have to transfer all my drop down lists over to the other workbook?

Regards

Steve