I have a few calculation intensive spreadsheets, which take a long time to calculate completely. But all too often, I have to run goalseek/solver on a few lines, to quickly get a result.

However, every time I use goalseek/solver, the entire spreadsheet recalculates repeatedly (including areas which are not relevant to the particular solution).

Do we have a work-around this? Say I could define that goalseek should only re-calc rows 1 and 2, while solving for J2 equal to 0, by changing B2.

Thanks a lot!