Data table with different data input

[Tmidjord]

I have created a data table used to show contribution margins at different fee levels. The numbers for the contribution margin calculation comes from different worksheets depending on the choice you make in a drop-down menu.

I have the correct calculations in my data table, but when I choose another worksheet in my drop-down menu the data table is only partially (or not at all) updated with the new data after I press F9, even though the data in my calculations are updated with the new data.

Anyone know what could be done to fix this?

Thanks in advance

 

[oldbrewer]

even though the data in my calculations are updated with the new data.

what does this mean ?