That is correct. This is not a workbook setting.

--
Regards,
Tom Ogilvy


"julio" wrote in message
...
This is not really what i'm asking. I don't want the user to modify the
behavior of excel each time a new file is created, but rather, the fact
that
a file is opened based on the template would programatically determine the
modified behavior. Note that the "LinKs" menu is accessible only after
links
are created, so (unless i'm missing something) i can't save the *.xlt file
with "dont update" option active.
thnx
Julio
"Tom Ogilvy" wrote:

the prompt to update links is fired before any code runs.

You can have the links updated without prompt by going into
tools=Options
and on the edit tab, uncheck ask to update automatic links.

In xl2002 and later, you have an option to disable the prompt and not
update
under Edit=Links.

In versions earlier than xl2002, there is no option to not update
automatic
links and not prompt. You would need to open a 2nd workbook which uses
code
to open the workbook with links using

Workbooks.Open "NameofWorkbookwithLinks.xls", updateLinks:=0

--
regards,
Tom Ogilvy

"julio" wrote in message
...
I have an add-in linked to a template, based on which a file is
created.
When
the user opens this file, he is prompted about updating links.

To avoid it, I tried

sub Workbook_Open()
..........
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
........

which doesn't work, because the message pops up before _open is run.
How
do
I get this to work ???

Thanks