I don't think there's a reliable way (except for walking around and changing
that setting).

But another approach is to use a dummy workbook that opens the workbook with
links. You can have that dummy workbook open your real workbook anyway you
want.

The dummy workbook would contain a macro like this:

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.)

But now you have a different problem--you have to make sure that the user opens
the file with macros enabled.

I add some notes to Sheet1:

Please close this workbook with macros enabled.
(Repeated about 20 times)

Then if macros are enabled, the message disappears quickly.

If macros are disabled, then the users can read the message and do what they
want/need to do.

ceemo wrote:

is there any other way to this just to this spreadsheet for all users

--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=399731

--

Dave Peterson