Data validation lists change source designation when list data is updated.

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.

The lists are all hard coded

Hi Glen, I just used my test shreadsheet and changed the first two groups of lists to offset as per your code and made sure that the next two were on the old code, I then inserted about 10 blank lines into the list and I got a mixed result. The first two with offset worked perfectly, the third also worked, but then again it seemed not to affect the first group in previous failings, but the fourth group failed losing the page identifier as per always. I will change all of the groups to offset and start playing with the data big time and see if it will eventually break, my first impression is that it's going to work, many thanks.