View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Latika Latika is offline
external usenet poster
 
Posts: 6
Default Using Solver with Data Table

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