Not recalculating correctly

[Steven811]

Hi

I'm set to autorecalc

I have a several rows of drop down lists and when an option is selected it provides a reference that is used calculate a simple costing.

My problem is that unless the drop down list in row 2 (one of 15) is selected also, all of the other drop down calcs show the same incorrect calculation. As soon as row 2 list is selected then they all recalc correctly.

Any ideas please would be much appreciated.

Thanks

Steven811

[Pete_UK]

It would help if you could post an example file, as we can't see what formulae you are using.

Pete