i have a cell having function of NOW(), but it is not continuously updated unless the workbook is not calculated or F9 is not pressed, i want the cell to be auto updated, please help me.