Updating The worksheet on click.

I have a worksheet with a lot of SUMPRODUCT formulas so it takes a long time to calculate everything everytime I do something minor like add a column.
Is there a way so that only when I click a button or tell it to update then it will update the worksheet, so I dont have to wait a long time everytime?

Thanks

Thanks, this seems to work well.

I need to do the same thing with A LOT of arrays. How can I simplify the process to where I don't have to click on the cell, click in the formula bar, and then ctrl+shift+enter to update?

Thanks!