Auto Link Update

When i sign into my spreadsheet it asks whether i would like to update links. Is there anyway to get this to auto update without it prompting me. Basicaly taking away the choice from the user?

You can change the setting for you.

Tools|options|Edit tab
Uncheck "ask to update automatic links"

The links will be refreshed and you won't be prompted.

But this is a setting that's local to you--each user controls what he/she wants
to do.



ceemo wrote:
>
> When i sign into my spreadsheet it asks whether i would like to update
> links. Is there anyway to get this to auto update without it prompting
> me. Basicaly taking away the choice from the user?
>
> --
> 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

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

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