I don't know how to do what you want, but <Ctrl><Alt><F9> will updateit.I believe that with Excel (from Excel 2000 onwards), this can be donein VBA with the commandApplication.CalculateFull