Using Solver with Data Table

[Latika]

Hi,

I have created a one-entry data table with 1000 trials. I want to use
Solver to minimize the average value in the data table by changing weights on
a corresponding portfolio. However, when I manually change the weights and
then ask Solver to re-solve, it gives me a different result. Any one have
any ideas? Does Solver not work well with data tables? Is there a way
around this?

Thank you!!
Latika