If you give an example of the layout, and the formulas that you're using
in the Data Validation cells, someone may be able to help.

Buzz wrote:
I have a spreadsheet where i have created a number of drop down lists using
data validation. These lists refer to cells which in turn refer to other
cells. I some of the Drop downs I created the cells update due to changes in
data elsewhere in the sheet, however in others they don't., I wouls like them
all to update.

I cant see what I doing wrong any assistance great fully recieved.