Hi Again, I have numerous data validation lists that point to data stored on a seperate worksheet, it works perfectly until I alter, change or update the data then it drops the reference to the other worksheet just leaving the cell range addresses which I presume relates to the same page as the lists, is there any way to lock the source address so it cannot change?
Here is the correct address: =Ingredients_Page!$C$2:$C$167 and this is what it changes to when I do anything with the data: =$C$2:$C$167.