If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:
Kind of like:
Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub
Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)
Then have the users open the dummy workbook.
ceemo wrote:
Thanks for the reply.
Does anyone know of any other way around this as other users will be
using this workbook. Perhaps something coded in VB ??
--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=548628
--
Dave Peterson