you can try having a macro run every time you load the sheet that sets
off a timer to run a macro to clear the cells every hour or so. this
would not give you the most up to date but within an hour of when the
data becomes obsolete it would be cleared.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=474731