the above answer is wrong! you can't omit constituents from the portfolio, optimize, and then add them back subsequently. you need to optimize the entire portfolio!
i have the same question as the original poster. does anyone have a valid answer? i've tried putting the min and max weightings at the current portfolio weight and running an optimization. instead of holding the weights steady, the spreadsheet still pumps out different weights. does anyone have a valid answer?
