Excel notices the links before your code starts. So anything you do in this
workbook, won't help this workbook--but will "help" the next one.

Saved from a previous post:

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.
(read about that UpdateLinks argument in VBA's help.)

CAPTGNVR wrote:

DEAR ALL

I have put this code in the 'on open worksheet' --
Application.AskToUpdateLinks = False--.
But still do get the opening message when i open the file that it
contains links to another sheet - to update or not. I do have the
links to another worksheet but i do not want this message to pop up.
Thanks to Mr., Dave, BOb n Gary, I am going to keep watching for every
10mints for the response.

--

Dave Peterson