Auto Open Help

StevenD

Active Member
Joined
Nov 17, 2004
Messages
262
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.
Code:
Application.DisplayAlerts = false
but doesn't work.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
StevenD said:
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?
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,312
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top