data validation

[Noz2k]

I have a cell which looks up a list of values in a sheet and puts these in a dropdown to select from. All works fine when I first create it, however if I then save and close my sheet. When I reopen it the dropdown doesn't work.

Any idea why this would be and how to fix it?

 

[anglais428]

Is the lookup reference being done in the same workbook?

 

[Noz2k]

Yes it is.

I have no idea why it isn't working, I had the same problem in another workbook of mine, but it's fixed now, and I can't remember how I fixed it or if it just fixed by luck rather than judgement.