MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Auto Refresh


Posted by Roy on November 12, 2001 11:17 AM

I have a worksheet that uses the NOW function to subtract a set time from the current time. This lapse is then used to generate a production output. I have put a refresh button on the sheet which updates the current date/time cell by running the now function when it is pressed. Is there a way to get excel to continually update the cell with real time.

Any help greatly appreciated

Roy


Posted by Roy on November 12, 2001 12:18 PM

Please help guys someone must know if this can be done