Saved from a similar question:

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.)

jesmin wrote:

Hi Dave Or anyone:

I am creating a report workbook file from my original workbook. The
report sheets have link to sheets in original workbook. So when I am
opening the report workbook, it is opening the Alert screen to update
or not. I DO NOt want to see this alert screen. I want to add some VB
code in my original progrm that will only grab the data from the data
sheets without reference.

Thanks

--
jesmin
------------------------------------------------------------------------
jesmin's Profile: http://www.excelforum.com/member.php...o&userid=29540
View this thread: http://www.excelforum.com/showthread...hreadid=515142

--

Dave Peterson