Refresh current Date & Time in Excel 2007
Posted on 2010-01-09
I have got the =NOW() function entered in a cell to display the current Date and Time. Right now it only refreshes when I enter or change the data in a cell somewhere in the worksheet. Can you tell me how to refresh it every 1 min or 2 min automatically, regardless of entries being made?
I've tried going to the Data tab and clicking the dropdown arrow under the Refresh button but the Connection Properties option is grayed out so I can't go in to set automatic refreshing.
Any suggestions would be much appreciated.