if this is for a table, you could right click on the table and select
table options
Enable 'Refresh on Open'. This will refresh the Table data everytime

the workbook is opened.


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=537612