2 Way Data Table issues when running monte carlo simulation

Hello Excel gurus,

I've spent the past 4 days running into an odd problem and despite searching all over the web and through various books, have not been able to determine the solution. I'm hoping one of you may be able to provide the answer to my problem.

The issue is that I've noticed that as I try to run monte carlo simulations using 2 way tables that sometimes the 2 way tables will work correctly by applying the formula throughout the data set of the table and then other times it will just copy the values in the row headers throughout the dataset.
This becomes extremely frustrating as I can never be sure when Excel will do it and when it will decide not to update the data set correctly.

I'm unaware whether there is a nuance to the use of the 2 way data table that I may be missing that is causing this issue or is there something I am blatantly doing wrong?

Typically I will set up my base equations and calculations; set the upper left corner of the data table to the equation, set up the left hand column under the equation to go from 1 to 1000 and then set up my row values in the row adjacent to the equation. Then I go to what if analysis in Excel 2007, select data tables, select the appropriate row and column and cross my fingers hoping it will work.

I've attached my examples to this email in the hopes that it may provide an idea of my issue.

Thanks in advance.

Best regards,
Alpesh