excel alert message

[ram]

When I open an excel file I get the following alert
message


This workbook contains links to other data sources.

If you update the links, excel attempts to retrieve the
latest data

If you don't update, Excel uses the previous Information.

How to prevent this ?
Please let me know

thanks
ram

 

[Dave Peterson]

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.

Try creating a dummy workbook whose only purpose is to open the original
workbook with links not updated:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=0
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links won't be refreshed.

And xl2002 added an option that allows the user to have more control:
Edit|links|startup prompt button.