Here is an example of how you can make the time update, and still be able to
work in the workbook. It uses the "Application.OnTime" function to schedule
the next call to a subroutine that updates the clock. The example updates
once a second, but you can easily set that to update once a minute.

http://j-walk.com/ss/excel/files/clockchart.htm