I don't believe there is a way to avoid this in xl2000 and earlier with a
setting. In xl2002 there is a setting to suppress this query (so you would
set it in the template - it is under the links option in the edit menu as I
recall - but if the workbook were opened in an earlier version, this would
not work).

UpdateRemoteReferences does not affect the question.

The way I would do this is open the template as a workbook, then saveas
using a new name so you don't overwrite your template. When you open the
template, set the updatelinks argument to 0

Workbooks.Open "C:\MyTemplate.xlt", UpdateLinks:=0
ActiveWorkbook.SaveAs "C:\MyTemplate1.xls", Fileformat:=xlWorkbookNormal

--
Regards,
tom Ogilvy




Newboy18 wrote in message
...
Hi thanks for the ideas but it still asks to Update Links
and the default checkbox is still set to Update Links
This is what I have so far:

ActiveWorkbook.UpdateRemoteReferences = False
Application.DisplayAlerts = False
Workbooks.Add templateStr
Application.DisplayAlerts = True
ActiveWorkbook.UpdateRemoteReferences = True


-----Original Message-----

"Newboy18" wrote
in message
...
Thanks, but because the default is to Update the links,
wont this do the same?


Would this help you?

ActiveWorkbook.UpdateRemoteReferences = False

(Insert in code before opening template, then set back
to true again
afterwards.)




.