Auto Open Help

[StevenD]

Hi,

I am automatically opening a workbook from within excel.

But I need to autoclose the box that appears asking about updating links.

I would like to cancel it.

I have tried.

Application.DisplayAlerts = false

but doesn't work.

 

[Andrew Poulsom]

The only way I know is to open a new workbook, uncheck "Ask to update automatic links" under Tools|Options|Edit tab, then open the workbook with the links.

Of course you could do that in code before opening the workbook:

Application.AskToUpdateLinks = False

 

[GlennUK]

Do you want the links to update or not? You decide what options you want on opening ... then the box doesn't display, but you haven't said what you want.

 

[StevenD]

Hi,

The code from Andrew works but it then opens another box.

this workbook contains 1 or more links that cannot be updated.

I can then click continue or edit links.

I just want it to continue.

 

[Andrew Poulsom]

Hi,

The code from Andrew works but it then opens another box.

this workbook contains 1 or more links that cannot be updated.

I can then click continue or edit links.

I just want it to continue.

I wonder why you are getting that message.

1. Do you have any links that refer to nonexistent workbooks?
2. Are any of your linked formulas returning #REF!?
3. Are there any names in the workbook that refer to a nonexistent range in an external workbook?