Just to add, any solution involving changing the user's settings using code,
will not work for the workbook being opened - at least not the first time it
is opened. The prompt appears before any macros are run.
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote in message
...
You can toggle the setting (user by user, though) via:
Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"
But this means that you suppress the question--the links still get
updated.
This setting is for the individual user--and affects all their workbooks.
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.
And xl2002 added an option that allows you to have more control:
Edit|links|startup prompt button.
check the "don't display the alert and update links"
Mick Southam wrote:
Hi
Can anyone help please, I need to automatically update links as a file
opens
without any user input.
--
Kind Regards
Mick
--
Dave Peterson