You would want to do this if you are editing your excel models and with each change of your model the excel sheet takes minutes to update all the formulas.
To disable the auto update in Excel 2007:
Formulas -> Calculations -> Calculation Options -> ManualIn pictures:
