Tools|Options|Calculation, and check "Manual" Then you can re-enter the
individual formulas that you want recalculated (select the cell, put the
cursor into the formula bar and press Enter [or Ctrl-Shift-Enter if it
is an array formula]).

Jerry

Dobey Kweeg wrote:

I know you can manually recalculate a workbook by pressing f9, or an
individual sheet by pressing shift f9, but can you recalculate specific cells
and leave other cells on the same sheet unchanged, where they do not refer to
one another? (This is in Excel 2003)