I have created a spreadsheet for customers with a summary sheet and a dedicated sheet for each customer. The last sheet has all the data vaildation lists. I have named each list and linked the name in each relevant cell on the customer sheets eg. =Practice.
Customers are still telling me that no drop down lists are appearing. they are using a mix of 97-03 and 2007 excel versions.
Any help much appreciated.