what is the difference between calculate now and calculate sheet?
With manual calculation turned on, you see “Calculate” in the status bar whenever your worksheet data changes and your formula results need to be updated. ... Click Calculate Now (or press F9) to recalculate every open worksheet. Click Calculate Sheet (or press Shift+F9) to recalculate only the active worksheet.