Hello Marc
have you found other alternatives for this?
this changes influence on all excel files and be made on many machines.
can a macro do the same just in one file?

on AutoOpen ... (something like that)???

stella

"Marc Daems" skrev:

Hello Dave,

Thanks, but I found already the answer at
http://support.microsoft.com/default.aspx/kb/248204

Reg, Marc


"davesexcel" wrote:


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