Excel Solver

[madpak2]

I am wanting to use Excel Solver to find find the weights, standard deviation, and variance at a specific return%. When I go and use solver and click solve the parts in yellow beside the target return % does not change. Can anyone help me fix it?  I need it for a homework assignment to work. 

[#2]

@madpak2 

There must be something missing - all other weights are set to 0, so all weighted calculations will return 0 regardless of the values in Q3:Z3.

[#3]

I went and changed the weights in q3:z3 to having nothing in them and I am still not able to have any of the information changed.

[#4]

@madpak2 

Of course not - all results will still be 0.

[#5]

Then how do I get it to solve for the weights, standard deviation, and variance at a specific return%? I got it to work on another document with just 4 stocks.

[#6]

@madpak2 

I have no idea.